import oracle 8i fulldb data into oracle 9i
Posted on 2004-09-09
i have the fulldb export file of oracle 8i.
i have another oracle server which is 9i
when i try to import the fulldb dmp(oracle8i) into oracle 9i using 9i client, it gives following errors
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
i open the dmp file but there is no where define "dictionary managed" in create tablespace command.
what should be the solutions for this.
i dont want to seperately creat all schema and then import using fromuser to touser....