 Import data into a new tablespace [message #180241] |
Sat, 01 July 2006 06:39  |
jaimon
Messages: 1
Registered: July 2006
Location: BANGALORE
|
Junior Member |
|
|
I tried to change by
ALTER USER USERNAME DEFAULT TABLESPACE TABLE_SPACE_NAME TEMPORARY TABLESPACE TABLE_SPACE_NAME
/
REVOKE UNLIMITED TABLESPACE FROM USERNAME
/
ALTER USER USERNAME QUOTA UNLIMITED on TABLE_SPACE_NAME
/
ALTER USER USERNAME QUOTA UNLIMITED ON TABLE_SPACE_NAME
/
Even though it import to the new table space certian constraints do not get imported properly.
Ex : -
.............
IMP-00015: following statement failed because the object already exists:
"ALTER TABLE "ABC" ADD PRIMARY KEY ("ART_ID") USING INDEX PCTFREE 10 INITRA"
"NS 2 MAXTRANS 255 STORAGE(INITIAL 40960 FREELISTS 1 FREELIST GROUPS 1) TABL"
"ESPACE "SYSTEM" LOGGING ENABLE"
.................
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "KUNDE" ADD FOREIGN KEY ("PDK_NR2") REFERENCES "PRODUKTION" ("P"
"DK_ID") ENABLE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
.............
Please help me if anybody has a clue
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
