As the header says, I get a
ora-01013 (Insufficient Privileges) when I do
sqlplus /nolog
connect / as sysdba

How do you specifiy that you want a log file or dump file to be written
to a path that is a mapped drive to a location on another computer?
In other words, I want to be able to specify
"CREATE DIRECTORY MY_DIR AS 'Y:\'"  // where "Y:\" is is mapped to

I'm getting slow data transfer between a client and a server. NIC
Speed/Duplex etc has been checked.
I've a Windows client which is showing a 64k TCP window size (viewing
with Ethereal) when communicating with an Oracle DB running on HP-UX.

having a table
t (id integer, sub_id integer)
how is it possible to autoincrement the sub_id per id?
The table should simply be filled like that:

I have written the following Procedure and i get errors.
DECLARE
cursor c1 is select constraint_name,table_name from user_constraints
where table_name ='CRF_DOCUMENT';

Can someone please ans the "Analyzing This Query?" msg part.
TIA

I needed a way of stripping a directory and a file extension from a
column in the database.
i.e. extracting 'File1'
from

Below is an extract from Performance Tuning Docs pg 14-21
"If an application makes an execute call for a SQL statement, and if
the executable
portion of the previously built SQL statement has been aged out (that

I'm sure I'm just missing something, but can't seem to find the answer.
We have a function that returns a REF CURSOR using the OPEN..FOR
syntax. The SQL for the cursor is dynamically built in the procedure
based on a series of configurations, such that the cursor will always

I have a table 'dipendenti' with a substitutable column of object:
SQL> desc dipendenti
Name                                      Null?    Type
----------------------------------------- -------- -----------------------

I installed the 10g software.  Then, I changed all my environment
variables to point to the new 10g Oracle Home directory.
When I run the DBUA, I get some weird UNSATISFIEDLINKERROR from the
DBUA.

I have a table (around 8000K rows) with an index
No error was reported with creating the index.
when I try to select data from the table via the index, I get
ORA-00600: code erreur interne, arguments : [12700], [28250], [33794730],

hi faculties
I ve used DBVERIFY tool to check the datafiles from my database. I
issued the following command:
C:\> dbv file=e:\oradata\ark2\idx\ark2_idx1.dbf

I would like to share one situation regarding the oracle Cluster Manager with
you all.Hope you will come forward and do let me know the best i can do for
it.
Before I ask you the question,I would like all of you to understand my

I need to copy a 7 million table from a remote db via dblink.
Wich method would you recommend, what things should I consider ?
1- create table copied_table nologging as select * from
original_table@remote_db;