why not just copy over your complete hot backup? If you need it to be as up to date as possible, you could do it as a standby database and apply logs until you are ready and then open the standby database and you will have an exact copy.
Transportable tablespaces have some caveats -- and the SYSTEM tablespace is not transportable. So if you used them, you wouldn't have an exact copy. Rachel --- "Daiminger, Helmut" <[EMAIL PROTECTED]> 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 > > __________________________________________________ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).