Copy datafiles or export?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Copy datafiles or export?

  1. #1
    Join Date
    Apr 2001
    Location
    Toledo, OH USA
    Posts
    1

    Question

    We have two instances on an HP9000 unix server running 8.1.6.

    TSAP is production and TSAD is development.

    At one time our DBA had me shut down both instances, copy the data files from TSAP to TSAD, rename the files, and startup the databases.

    This made an exact copy of the data in production for development use.

    Since our DBA is no longer with us, and I'm still learning, I cannot remember all the steps involved.

    Is there anything I need to do besides shutdown, copy/rename, restart?

    How does copying the datafiles compare to using import/export?

    Thanks in advance,
    Tim


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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