I am new to  oracle and I am facing a  dilemma for now. I have 4
tableslaid out in a following fashion.
Table 1: Primary Key User_ID maps to table 2 's user_id and profile_id
Table 2: Has 2 primary keys user_id and profile_id

I am new to  oracle and I am facing a  dilemma for now. I have 4
tableslaid out in a following fashion.
Table 1: Primary Key User_ID maps to table 2 's user_id and profile_id
Table 2: Has 2 primary keys user_id and profile_id

We have successfully migrated 600 Gb database for a banking client from
SUN to AIX in 7 hrs.we had several pilot runs before the final ball.
we used following parameters during export
db_file_multiblock_read_count=20480

It's Monday and I'm having a problem grasping how to do something.  Does
anyone have a vanilla example of how to create, fill, cursor off of an
associative array?
I'm trying to manipulate some text (varchar2 column) for a report to put in

he
hot to store CLOB data to file using enterprise manager or SQL plus. When I
trie save report to file it stores only 1000 chars
I have Oracle 10;

I am on HP UNIX 11i using Oracle 9.2.0.5.
I had a database in database character set  US7ASCII. I recently
converted it to database character set UTF8. Since I do not have any
nchar or nvarchar2 columns, national character set is irrelevant even

I have a table (well, 2 tables joined) with a hierarchial parent/child
record structure.
I can order other such tables just fine with SQL like:
     SELECT

Hi, I have a view (a few tables join) that contains a few million rows,
lets call it myview, one of the column is ID, now I have a long list
(say 700) of ID's that need to be filtered with myview, so the query is
something like:

We have a two node Oracle RAC cluster (10.2g on Linux), which we will
be accessing via weblogic (8.1 sp5 on Linux) and we are working to
connect the two using the JDBC thin driver.
We are trying to setup the connection pools on the weblogic side so

sdf

Hey, I have a new site: http://www.wizardsolutionsusa.com
If you are in need of help or like to give help to others,
then you may find it useful.  Remember, it only takes 90
seconds to sign up at the forum and ask a question or

We're pretty new at using Materialized Views, so.......
We have a materialized view:  SPECIAL_TST.  It seems that the base
table also has the same name.  So, when I try and insert, I get an
ORA-01732.

RDBMS Version: 10.1.0.2.0
Operating System and Version: HP-UX B.11.23 U ia64
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): Oracle JVM

Is there a way to recompile all invalid objects in PL/SQL??
Currently we use the build-in functionality of PL/SQL Developer to
recompile all invalid object after a database update.
But I would like to add this to the end of our update script so the

I would like to know how I can Audit the schema changes done using
ALTER TABLE, DROP TABLE, CREATE TABLE for an Oracle DB.
Thanks,
Tuhin