Search results for query: *

Mufasa thanks a lot for your suggestion. I have tried to run the script using your example but it is giving me following errors. P2-0042: unknown command "..." - rest of line ignored. SQL> Accept foo PROMPT "Pausing...Press [Enter]-key to continue processing: " Pausing...Press [Enter]-key to...

I'm run scripts as below in sqlplus with different schema user. @$PATH/create_table.sql @$PATH/alter_table.sql @$PATH/constraint.sql @$PATH/sequence.sql but interesting connection to different schema user disconnected I'm when I'm using pause in execution set pause on set pause PLEASE...

check the oracle driver on the machine as first point of the trouble shoot

Anyone tell me procedure to restore database with different name from cold backup Thanks in advance

I have different schema like user,hr,payroll in sh script. Right now I'm using connect user/user are hardcord in script. I'm looking how to use variable for each user in sh script instead of specifying indidual connection for each user when running scripts releated to each schema user. Thanks...

Thanks Dave it works. Now second hurdle I have connecting different schema users like user, hr,payroll. How to connect different users using varible when running upgrade script on oracle instance in sh script instead of using connect user/user with every connection Thanks in advance Ron

First find out uisng profile tsql statement causing the deadlock. You can use locks option in profiler. Tell me how it goes

thanks all for your input

I have scripts files in oracle/home/scripts how to set this directory path in sqlplus in order to get files and execute from this directory. Thanks in advance

Yes creating a test environment. I'm planning to move coldbackup files of oracle instance which is oracle9i to another aix box where 10 g installed. I need to know how to copy data files from one aix to another aix box.

Any one help me with steps in copying oracle db files exits on one aix box to another box Thanks in advance