Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Oracle 8i export to Oracle 9i import.

Oracle 8i export to Oracle 9i import.

From: Jaehne, Richard S <JaehneRS_at_state.gov>
Date: Tue, 1 Feb 2005 16:46:27 -0500
Message-ID: <2BF02E41764FE640B254C590B169C85C05A71BC0@MSWASHDCMB02.irm.state.gov>


All,
I need to migrate my production database from Oracle 8i to my new Oracle 9i database server. One problem I'm having is that the directory structure on the new server is different than the old server. So when the import tries to create the TEMP_TS or RBS DBFs we get an error that it doesn't exist. Then because it failed to build TEMP the user imports fail because it can't grab the TEMP_TS tablespace for their temporary tablespace. I could just export/import the tables piecemeal but I would rather do a full imp/exp so we can get the grants, triggers etc. Is there a workaround for this?

Thanks,

Sean Jaehne

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 01 2005 - 16:49:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US