Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: Database Objects Replication in New Database

    Hi

    I have an Oracle 9i database on Windows 2000.
    I created another database on the same Windows server. I want to replicate all the tables and stored procedures that I have in the existing database to the new database. Import does not help because the SID is different. Is there any way to duplicate all the tables and stored procedures in the new database from the old database without manually recreating them?
    Kindly advise

    Nav

  2. #2
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    Yes,
    Export with the SID of your first database.
    Then
    $ ORACLE_SID=db2,export ORACLE_SID

    (this is how you change your sid on unix - there must be a way of doing it on windows)

    now your SID is pointing to your new database.

    Now do your import.

    Rgs,
    Breen.

Posting Permissions

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