RE: How to move 200 GB db from prod to dev?

[David Wagoner]

Title: How to move 200 GB db from prod to dev?

Search the Oracle-L archives- this question has been covered several times recently.   Also, “Oracle DBA Tips & Techniques” by Sumit Sarin (2000, Oracle Press) has detailed instructions for cloning a database in Chapter 1.  Note the error in the script on page 43:  “create controlfile REUSE database…” should be “create controlfile SET database…”.  Otherwise, the procedure works wonderfully.      “Successful?  Begun the clone wars have.” –Master Yoda     HTH,     david   David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Office (919) 466-6723 Pager [EMAIL PROTECTED] Fax (919) 466-6783 http://www.arsenaldigital.com/                                                                                                             ***  NOTICE  *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law.  If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer.  Thank you.   -----Original Message----- From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Subject: How to move 200 GB db from prod to dev?   Hi! We are supposed to clone our production database onto a new development box (both boxes are Sun Solaris). The db is about 200 GB in size. What would be the best way to achieve this? Simply copying over the files won't work, since the instance names are different: Production:  SID=PCLDB1 => e.g. /u02/oradata/PCLDB1/system01.dbf Development: SID=ROLAND => e.g. /u02/oradata/ROLAND/system01.dbf So would export/import the entire db be the only way? (But writing out dump file that big should be a little disk space problem...) Renaming all the datafiles (approx. 100) would be kind of annoying... Any ideas? This is 8.1.7 on Sun Solaris. Thanks, Helmut