I already installed the software. Before I go ahead and create a database, I'd like to know how I can create all the tablespaces exactly the same. Then I can do the full export/import of data. Thanks.
SELECT t.tablespace_name,SUM(f.bytes) as BYTES FROM dba_tablespaces t, dba_data_files f WHERE t.tablespace_name=f.tablespace_name GROUP BY t.tablespace_name ORDER BY 1;After you have created your tablespaces, you are ready to move your data. Perform a full export of your source database as follows:
exp userid=system/manager file=my_full_db.dmp full=yFTP the dump file in binary mode to your destination server, then import the entire dump file as follows:
imp userid=system/manager file=my_full_db.dmp full=y
This was first published in October 2005