I am trying to populate a database and find that several commands are
not available from SQL*PLUS.
These include SQLLOAD, EXP and IMP (error msg: 'enknown command').
I managed to get round the problem by IMPorting my data in Enterprise

I am trying to compile oracle libraries together.
I have noticed that the oracle libraries need to be compiled in a
certain order otherwise I am getting an Unresolved symbol messages.
What are the correct order of compiling oracle libraries?

I use SQL very few time and always tried to avoid using it. I use it but
only the basics I haven't really used SQL in several years. Since
sometimes, I have been thinking for any certification, which can enhance
my reputation and skills. How would be OCP. Tell me. Presently I’m ...

We are planning on using ASM, by understanding the benefits of it. I
have couple of things that I am trying understand...
1. Is this possible to have External redundancy w/ RAW devices ?
2. What are the advantages or disadvantages that are associated w/

I've been enforcing a uniform extent policy on a legacy database, so I've
been doing lots of "ALTER TABLE MOVE STORAGE ( ... )".  I'm mostly done
but there's one nagging exception: I can't set the next_extent property
on LOB indexes.  I've tried both of:

I want to create a program in PL/SQL or C/C++ to interpret and modify all
SQL statements coming to an Oracle server. Is it possible to hook such
program to the SQL parser of Oracle?
Any comment is appreciated.

I have a problem with my Oracle database 8.1.7.
I don't know if it is a security problem or known bug but i often lost
rollback segment's datafile. It appear deleted and my system fall down.
I have to drop tablespace with contents and recreate tablespace and his

I am trying to use an exec statement to run a script on Dbvisualizer.
However, I get this error
exec test1.sql
11:27:53  [EXEC - 0 row(s), 0.000 secs]  [Error Code: 900, SQL State:

I have a question with regards to the order seqeunce.. I have data that
is displayed by id numbers. The id numbers are 1,2,3,4,5,6,8,9,10 .. Is
there a sql statement that will allow the id to sort like this:
1,2,8,3,4,5,6,9,10 ?

i'd like to know if is it possible to change IP address on win 2000
server and Oracle 9i Aplication Server 1.0.2.2.2a will work? It will be
painful to reinstall everything.
many thanks,

Have an Oracle 8.1.7.0 database running multiple instances. The problem
is that for one of the instance, any schema is unable to refresh
materialized views. When trying to do a complete refresh for any
materialized view for any schema, Oracle returns with the following

I have a table
person_id    start_month      end_month
1             200301           200303
1             200302           200303

recommended configuration for a production database.  However, the
problem we have is that Archive Logs files in the ..\RDBMS\ directory
are accumulating daily which has implications when you have limited

I'm on WinXP, and I have been using forms6i and Discoverer 4 to connect
to a 7.3.4 db.  All was working well, even after adding 10g client.
Then these 2 apps which use net8 began having ORA-12571 TNS packet
writer failure errors.  I can't figure out what happened or how to

I have create a job using dbms_job.isubmit but the job just will not
execute when scheduled. I am new to Oracle Job package and I cannot
figure out why my scheduled job will not run when scheduled.
If I run the job with dbms_job.run(1000) the job executes the procedure