Home » RDBMS Server » Server Utilities » IMPDP (Redhat linux)
IMPDP [message #470760] Tue, 10 August 2010 11:30 Go to next message
Marnickxs
Messages: 9
Registered: August 2010
Location: The Netherlands
Junior Member
Hi,

I want to import a schema from one database schema to another schema b

from db STBTST to STATST and from schema CMSSTAGINGB to CMSSTAGINGA

I first want to test this to my own schema (mvanmannekes)
CMSSTAGINGA is filled at the moment.

So i've created a dump from STBTST-CMSTAGINGB
For importing im using this statement:

impdp mvanmannekes/password schemas=cmsstagingb remap_tablespace=cmsliveb_data:cmslivea_data
remap_tablespace=cmsliveb_index:cmslivea_index
remap_schema=cmsstagingb:mvanmannekes directory=expdp_dir dumpfile=cmstagingb.dmp


I'm getting this:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "MVANMANNEKES"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "MVANMANNEKES"."SYS_IMPORT_SCHEMA_01": mvanmannekes/********
schemas=cmsstagingb remap_tablespace=cmsliveb_data:cmslivea_data
remap_tablespace=cmsliveb_index:cmslivea_index
remap_schema=cmsstagingb:mvanmannekes directory=expdp_dir dumpfile=cmstagingb.dmp
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE failed to create with error:
ORA-00959: tablespace 'CMSSTAGINGB_DATA' does not exist
Failing sql is:
CREATE TABLE "MVANMANNEKES"."BOL_CONTENT_MENU_PROPS" ("ID" VARCHAR2(254)
CONSTRAINT "BOL_CMS_CHK01" NOT NULL ENABLE NOVALIDATE, "TAB_CSS_NAME"
VARCHAR2(254), "TAB_ACCESS_KEY" VARCHAR2(254), "ACL" VARCHAR2(4000))
PCTFREE 10 PCTUSED 0 INITRANS 40 MAXTRANS 255 NOCOMPRESS
LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1
MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIS

Why?
Re: IMPDP [message #470762 is a reply to message #470760] Tue, 10 August 2010 11:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10628
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>ORA-00959: tablespace 'CMSSTAGINGB_DATA' does not exist

Tells it all.
Re: IMPDP [message #470763 is a reply to message #470762] Tue, 10 August 2010 11:34 Go to previous messageGo to next message
Marnickxs
Messages: 9
Registered: August 2010
Location: The Netherlands
Junior Member
Thats true...but why its expecting tablespace CMSSTAGINGB_DATA there is no refer to that tablespace.
Re: IMPDP [message #470769 is a reply to message #470763] Tue, 10 August 2010 11:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10628
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Is that a complete log output?
Seems some information is been truncated.
I would check the default tablespace in source.
If nothing works,
try with TRANSFORM parameter.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_import.htm
Re: IMPDP [message #470847 is a reply to message #470769] Wed, 11 August 2010 02:09 Go to previous message
Marnickxs
Messages: 9
Registered: August 2010
Location: The Netherlands
Junior Member
The default tablespace was indeed a different one.
Thanks!
Previous Topic: Flashback in Oracle 11g
Next Topic: Known bugs AWR Report and Snapshots?
Goto Forum:
  


Current Time: Mon Oct 20 00:39:59 CDT 2014

Total time taken to generate the page: 0.12656 seconds