Hi All ,
Greetings.
.
I am on oracle 11g and Unix SPARC Os.
I am trying to import a schema from production to development
using traditional IMP .
The problem is :
In production tablespace A exists whereas we have used an existing tablespace B for that schema import.
In production the schema creation is :
create user fgfgf
identified by ddf
default tablespace A
Whereas in dev I have used :
create user fgfgf
identified by dfd
default tablespace B
While importing everything is getting imported except 2 advanced queue tables , which are failing because the error says , tablespace A ( from Production) does not exist.
How should i resolve this error ?
1.Should i create a tablespace A and then import only these 2 tables which are erroring out ?
If yes , then while i gave create user default tablespace , why is it not taking that ?
2.Should I manually create these tables by editing the create table script( from production) so that it goes to tablespace B and then import ? would it then ignore the create table statement which it uses during import ?
Please suggest.
Below is the error what I am getting :
IMP-00017: following statement failed with ORACLE error 959:
"CREATE TABLE "AQ$_xxx_xxx_xxx_xxx_xxxx" ("MSGID" RAW(16), "SUBSCRIBER#" N"
"UMBER, "NAME" VARCHAR2(30), "ADDRESS#" NUMBER, "SIGN" "SYS"."AQ$_SIG_PROP","
" "DBS_SIGN" "SYS"."AQ$_SIG_PROP", PRIMARY KEY ("MSGID", "SUBSCRIBER#", "NA"
"ME", "ADDRESS#") ENABLE) USAGE QUEUE ORGANIZATION INDEX PCTFREE 10 INITRAN"
"S 2 MAXTRANS 255 STORAGE(INITIAL 10485760 NEXT 10485760 MINEXTENTS 1 FREELI"
"STS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "MCKB_DATA" LOGGING"
" NOCOMPRESS PCTTHRESHOLD 50 INCLUDING "SIGN" OVERFLOW PCTFREE 10 PCTUSED 40"
" INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 10485760 NEXT 10485760 MI"
"NEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "A""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'A' does not exist
Thanks
Kk
Edited by: Kk on Jul 14, 2011 4:29 AM
Edited by: Kk on Jul 14, 2011 5:00 AM