Coppying instance to another instance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Coppying instance to another instance

  1. #1
    Join Date
    Nov 2002
    Location
    hydreabad
    Posts
    34

    Thumbs up Coppying instance to another instance

    HI Experts

    Iwant to copy the one scema data to another intance ( running in another mechine)
    How ill do that>
    Advanced thanks

    (donto say import and export)

    some thing like transport tablespaces

    Thanks & Regards
    KVV
    Venkata vara Prasad Kosaraju

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    whats wrong with exp and import - thats what it is for ya know.

    Could spool off the data to a csv file and use sqlldr but whats the big issue with exp/imp

  3. #3
    Join Date
    Jun 2003
    Location
    India
    Posts
    118
    Use Exp/Imp option.
    vishal sood
    OCP 8

  4. #4
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    You can use transportable tablespaces, but you must put the tablespace in question in read only mode. If this is your production db, then you have a problem.

    Normal export is possible while users are present.

    alter tablespace x read only;
    and then something like:
    exp transport_tablespace=Y tablespaces=x
    and after that the same in imp.exe.

    Use EXP HELP=Y and IMP HELP=Y in your command prompt for the complete set of parameters.

    HTH,
    Erik

    PS: Don't forget to write-enable the source ts...

    PSPS: To my knowledge, this question was already solved once. Please try to search the site before posting your question. It saves you the time of typing your story
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.

  5. #5
    Join Date
    Jan 2001
    Posts
    3,131
    I would never say import/export, I would however suggest export/import, that would make a lot more sense.



    MH
    I remember when this place was cool.

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