Cloning database - Win2k & SQL*Plus
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Cloning database - Win2k & SQL*Plus

  1. #1
    Join Date
    Jan 2001
    Posts
    30
    Cloning a database on 8.1.7/Windows 2000

    I'm having problems cloning a database on a 8.1.7/Windows 2000 server.
    I've done this many times on an 8.0.5/NT server with problems.
    I follow the steps as listed in doc 73301.1 up until the ORADIM command. It appears that the Oradim command starts ups the database in exclusive mode. Is something new to 8.1.7. Also, I'd like to use SQL/Plus to connect the instance and issue the create database script, but I can't connect. I know we should use SVRMGRL, but that of course doesn't work with Terminal Server.

    So, a long winded lead up to: Has anyone done database cloning on 8.1.7/Windows 2000 using SQL/Plus?





  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    First connect to the database as sys user and then issue

    Code:
      SQL> connect / as sysdba
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width