I am having all kinds of connection issues with sql developer all of a sudden. It was working till yesterday and stopped working on windows 8 machine.
i am still able to connect via command prompt.
...

I have a schema with some database links to other schemas that we use to pull data from. We pull the data into a staging table, massage it, and then do some merges into our schema/database.
The data ...

We experienced a problem recently where the disc space ran low and some queries started giving unpredictable results. The root cause was that we'd take too many restore points and filled up the disc.
...

Running Oracle 11g 11.2.0.1.0
Server mysteriously stopped accepting connections to its databases. In other words, you run sqlplus and try connecting as any account and get an error that the listener ...

I am attempting to build a report for a client. I need a display of all the values in Tab1, Col1 (a validation table), a count of each time that occurred, and a percentage of the total. Here's what ...

Using - Oracle 11g
I have created a table say X. of this table, a column say C3 is a computed column which will have a value based on incoming values for the other 2 columns say C1 and C2. I am using ...

How to find out when a query was executed? I ran a query couple of days ago, I'm not sure about the exact time. I want to know at what date and time the query was executed.
Is it possible to get that ...

Let's say i have created a user as 'TEST_USER', and then i assigned a profile to it.
Now how can i see for TEST_USER which profile has been assigned?
I want some query that will check what profile a ...

We have oracle 11gr1 rac two instances on two different servers, new undo tablespace UNDOTBS20140508 created 30G, I want to remove the old one UNDOTBSX02, I did the following:
CREATE UNDO TABLESPACE ...

Due to hardware failure after a power outage we had to recreate the database for one of our 3rd party applications from an dumpfile (created via exp). The old hardware had Oracle 10G R2 running while ...

I've encountered a very interesting problem that I can't figure out how to fix. I have a package that I wanted to create on my database with a wrapped body. I mistakenly omitted the word "BODY" from ...

I'm working with Microsoft Reporting Services 2008. In our database, we have a small group of confidential students that need to be taken into account for several queries. If they are a confidential ...

I have a table structure (in an Oracle 11g database [11.2.0.3.0]) that maps out a folder hierarchy for employee records that looks like this (note: I have to start at the leaf node and recurse up to ...

I inherited an old script, that should, as part of a pl/sql routine, create a temporary index for me. I tried it on Oracle 11.2.0.4.0, but it does not accept the options.
CREATE INDEX x ON y(gid) {IN ...

I've restored a db and its failed with many errors. When I look into the log file, I found that the tablespace does not exist. So when I try to create a tablespace in plsql am getting the following ...

In Oracle 11g, is there a way to introduce subpartitions into an existing partitioned table?
I cannot seem to find a combination of EXCHANGE and SPLIT partition that does the right thing. SPLIT will ...

I have to select child items from a parent item and then compare text of each child and if the text is same I should not be displaying the heading. I have written a procedure for this, which is like ...

I am having a problem in Oracle rollback.
In my stored procedure I have multiple insert and update statements.
If every thing is fine I am sending success message and also I am tracing success status ...

I am trying to update multiple columns from multiple tables. My query like below but this is not working , how can write in correct way to update this.
UPDATE Z_test_agl_asset a
Z_test_cust_att c ON ...