Home » RDBMS Server » Server Utilities » database import problem (in Oracle database 11g Release 2)
database import problem [message #545279] Tue, 28 February 2012 04:07 Go to next message
puspa
Messages: 7
Registered: February 2012
Junior Member
Dear Sir/Madam,

I am currently using Oracle Database 11g Relaese 2(version 11.2.0.1.0) in RedHat Linux 5 server. I have a oracle database dump file (e.g. discard2009dec.dmp) which was exported from Oracle Database 10g Relaese 2 (Version 10.2.0.4).

Now I want to import discard2009dec.dmp file (Taken from Oracle Database 10g Relaese 2 Version 10.2.0.4) into Oracle Database 11g Relaese 2(version 11.2.0.1.0).

#imp sys/Nstpl321 FROMUSER=INTRACE TOUSER=INTRACE FILE=discard2009dec.dmp COMMIT=Y IGNORE=Y BUFFER=1000000

BUT it gives errors like

ORA-00959: tablespace 'INTRACE' does not exist
ORA-00959: tablespace 'DISC_TR_20091201_D' does not exist
ORA-00959: tablespace 'DISC_TR_20091202_D' does not exist
ORA-00959: tablespace 'DISC_TR_20091203_D' does not exist

How Can I solve this proplem? Please suggest me ASAP.................................
Re: database import problem [message #545287 is a reply to message #545279] Tue, 28 February 2012 04:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Either use data pump or pre-create the tablespaces.

Regards
Michel
Re: database import problem [message #545336 is a reply to message #545287] Tue, 28 February 2012 09:06 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Michel Cadot wrote on Tue, 28 February 2012 05:34
Either use data pump or pre-create the tablespaces.

Regards
Michel


Or...pre-create the tables.

[Updated on: Tue, 28 February 2012 09:45] by Moderator

Report message to a moderator

Re: database import problem [message #545339 is a reply to message #545336] Tue, 28 February 2012 09:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which does not help if indexes or LOBs are in these tablespaces.

Regards
Michel
Re: database import problem [message #545351 is a reply to message #545339] Tue, 28 February 2012 11:09 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
It will help if you create the table(s) correctly (with lob storage), import without indexes and create these indexes later.


[Updated on: Tue, 28 February 2012 11:46] by Moderator

Report message to a moderator

Re: database import problem [message #545353 is a reply to message #545351] Tue, 28 February 2012 11:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Hmmm... simpler and easier to create the tablespaces. Smile

Regards
Michel
Re: database import problem [message #545355 is a reply to message #545353] Tue, 28 February 2012 12:53 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Definitely simple, but...

This may not be the case, but you can't believe how many times I receive this request: "We need to restore the October 2010 (whatever month) schemaA export (from production) into a new schema101O also in production and in a separate tablespace".

And obviously those old exports are (were) not datapump.

Using datapump is simplest.

Cheers!
Smile

[Updated on: Tue, 28 February 2012 13:19] by Moderator

Report message to a moderator

Re: database import problem [message #545368 is a reply to message #545287] Tue, 28 February 2012 22:44 Go to previous messageGo to next message
puspa
Messages: 7
Registered: February 2012
Junior Member
Thx. Michel,

How do we know,how many tablespace are there in *.dmp file ?

*.dmp file is exported with exp feature. Can we import it into new database with impdb ? How do we create tablespace ? please suggest me ASAP?
Re: database import problem [message #545369 is a reply to message #545355] Tue, 28 February 2012 23:05 Go to previous messageGo to next message
puspa
Messages: 7
Registered: February 2012
Junior Member
Hi LKBrwn_DBA,

My *.dmp file was exported from oracle 10.2.0.4 with exp feature. I don't know how many tablespace are there in *.dmp file. Can we import into oracle 11.2.0.1 with impdp ? How Can I do this ? ?
Re: database import problem [message #545370 is a reply to message #545368] Tue, 28 February 2012 23:07 Go to previous message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How do we know,how many tablespace are there in *.dmp file ?


Use imp with indexfile option then you have all the DDL contained in the dump and can find all the tablespaces.

Quote:
Can we import it into new database with impdb ?


It must be exported using expdp.

Quote:
How do we create tablespace ?


Using CREATE TABLESPACE statement, see Database SQL Reference.

Quote:
please suggest me ASAP?


ASAP, urgent and all this kind of words should be avoided in forum. You don't pay anything, you take our time (and we give it to you with pleasure), do not demand.

Regards
Michel
Previous Topic: EXP-00008: ORACLE error 933 encountered
Next Topic: Import Dump file (merged 2)
Goto Forum:
  


Current Time: Tue Mar 19 01:22:18 CDT 2024