create the tablespaces before you do the import
On Tue, 1 Feb 2005 16:46:27 -0500, Jaehne, Richard S <JaehneRS_at_state.gov> wrote:
> 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?
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 01 2005 - 17:55:06 CST
