| database import problem [message #545279] |
Tue, 28 February 2012 04:07  |
 |
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 #545355 is a reply to message #545353] |
Tue, 28 February 2012 12:53  |
 |
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!
[Updated on: Tue, 28 February 2012 13:19] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
| Re: database import problem [message #545370 is a reply to message #545368] |
Tue, 28 February 2012 23:07 |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
