Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Ron06
  • Order by date
  1. Ron06

    How to use pause in execution of scripts in sqlplus

    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...
  2. Ron06

    How to use pause in execution of scripts in sqlplus

    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...
  3. Ron06

    ODBC Connection failure to Oracle Database

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

    How to restore database with different name from cold backup

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

    How to run multiple user connections

    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...
  6. Ron06

    set file in directory for sqlplus

    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
  7. Ron06

    Deadlocks - Help

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

    set file in directory for sqlplus

    thanks all for your input
  9. Ron06

    set file in directory for sqlplus

    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
  10. Ron06

    How to copy oracle data files from one aix server to another aix serve

    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.
  11. Ron06

    How to copy oracle data files from one aix server to another aix serve

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

Part and Inventory Search

Back
Top