I have a large data warehouse running under 188.8.131.52. I want to transport it and upgrade to 10g on another server. What is the easiest way to move the data (on Unix)? It is too large to export/import? Thank you.
Have you looked at Transportable Tablespaces (TTS)? With TTS, you make the tablespaces READ ONLY and use the exp utility to create a small metadata file describing the contents of the tablespace. You then copy the tablespace's datafiles and the metadata dump file to your destination server. On the new database you plug in the TTS with the imp utility, but this only takes a minute regardless of the tablespace size. Look in the Oracle docs for
more information on TTS
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.