| Ora Import Error [message #167350] |
Wed, 12 April 2006 09:47  |
mmclough
Messages: 1
Registered: April 2006
|
Junior Member |
|
|
Hi,
I am trying to import a dump file from 8.1.7 to 10g.
I am experiencing two errors I cannot understand:
1) CREATE TABLESPACE "TEMP" DATATAFILE xxx.DBF' SIZE"
" 1048576000 REUSE DEFAULT STORAGE(INITIAL 65536 NEXT 65536 MINEXTENTS 1 MA"
"XEXTENTS 2147483645 PCTINCREASE 0) ONLINE TEMPORARY "
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
2) "CREATE USER "xxx" IDENTIFIED BY VALUES 'xxx' DEFAULT TABLESPACE "xxx" TEMPORARY TABLESPACE "xxx""
IMP-00003: ORACLE error 10615 encountered
ORA-10615: Invalid tablespace type for temporary tablespace
I am trying to avoid precreating all users and tablespaces due to the numbers involved. The syntax for the imp I am doing is:
imp xxx/yyy file=xxxexp.dmp log=xxx.log full=y destroy=y
Any help would be greatly appreciated.
Kind regards,
Mike
|
|
|
|
| Re: Ora Import Error [message #167360 is a reply to message #167350] |
Wed, 12 April 2006 11:04  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
In this case you may want to atleast pre-create the tablepaces with Locally managed extents..
In 10g you may not want to use DICTIONARY MANAGED TABLESPACES (Locally managed are preferred).
Since you have your SYSTEM tablespace as LMT, you cannot create anyother tablespace as DMT.
Read documentation for more information.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
