There are several ways to move a database :
1 : Shutdown the db and copy all the data files, redologfiles, control file and the parameter file to the dev box then open the db.
2 : Take a online backup of the database and then copy the control file, data files and the archiverfiles and do a incomplete recovery
3 : user RMAN duplicate command to make a copy of the database to the dev box
1 - 3 are fast and easy to do.
4: use transportable table spaces to move part of the database to the dev box is a possibility that work but requires more skills.
Daiminger, Helmut wrote:
Hi!
We want to put an exact copy of our production database (approx. 200 GB) onto a development box. What would be the best way to achieve this? Export/import would take kinda long... ;)
Would transportable tablespaces be the way to go?
This is 8.1.7 on Sun Solaris.
Thanks,
Helmut
-- /regards
Peter Gram Phone : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Målev http://miracleas.dk
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).