OraFAQ Forum: Backup & Recovery » import dump oracle 9i

Home » RDBMS Server » Backup & Recovery » import dump oracle 9i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

import dump oracle 9i [message #126982]

Thu, 07 July 2005 13:00

otb82
Messages: 2
Registered: July 2005

Junior Member

Hi,

I'am trying to import a database oracle 9i from a dump generated by EXP. To do that i have created a new instance ... and launched the folowing command :

imp system/manager file=intrafor.dmp log=import.log fromuser=intrafor touser=intrafor ignore=Y

imp system/manager file=intrafor.dmp log=import.log full=y ignore=Y

and here is the result

. importing INTRAFOR's objects into INTRAFOR
. . importing table              "CB_APPLICATIONS"
IMP-00058: ORACLE error 1552 encountered
ORA-01552: cannot use system rollback segment for non-system tablespace 'DATA'

and after :

IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace DATA

At the end of the execution (about 8 minutes later), tables are creted but EMPTY !

I have no idea how to solve the problem. Files are accessible (rean & write) ...

The rollbacksegment tablespace was created like that :

CREATE TABLESPACE RBS DATAFILE '/product/oracle/9.0.1/oradata/oradata/groupama/RBS_01_groupama_01.dbf' SIZE 10M REUSE
MINIMUM EXTENT 512K
DEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 4096);

According to me, the configuration seems to be valid ... but ... Sad