OraFAQ Forum: Server Utilities » Oracle 8i import problem

Home » RDBMS Server » Server Utilities » Oracle 8i import problem

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

Oracle 8i import problem [message #247491]

Tue, 26 June 2007 02:18

bardan
Messages: 1
Registered: June 2007
Location: Noida (India)

Junior Member

I have two users for DB. I tried to import the DB dump
file under separate user (User other than the user
who exported the dump file)

The imp command terminated with following errors.

IMP-ORACLE ERROR 604 encountered
ORA-00604: Error Occured at recursive SQL level 1
ORA-01653: Unable to extend table SYS.IDL_UB2$ by 16 in tablespace SYSTEM
ORA-27039: Create file failed, file size limit reached

few other errors also occured,like ERROR 1658 etc
only some of the tables were imported (around 261 of 380)

Please analyse and find solution.

Christas

Report message to a moderator

Re: Oracle 8i import problem [message #247496 is a reply to message #247491]

Tue, 26 June 2007 02:34

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

ORA-27039: Create file failed, file size limit reached

ora-27039: create file failed, file size limit reached
 *Cause:  an attempt was made to create a file that exceeds the process's
          file size limit, additional information indicates which function
          encountered the error
 *Action: raise the file size limit

You seem to have an OS limit on file size.
Limit the growth of your file below this limit using maxsize if your file are in auto-extend mode.
Add a new datafile to your tablespace SYSTEM.

Quote:

ERROR 1658

Don't create user objects in SYSTEM tablespace.
Don't allow any user to have SYSTEM tablespace as default one.
Don't grant quota on SYSTEM talespace to any user but Oracle ones.

Regards
Michel

Report message to a moderator

Re: Oracle 8i import problem [message #247626 is a reply to message #247496]

Tue, 26 June 2007 10:39

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Use fromuser touser clause for import.

Report message to a moderator

Re: Oracle 8i import problem [message #247635 is a reply to message #247626]

Tue, 26 June 2007 11:02

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

How is this solving the error problem?

Regards
Michel

Report message to a moderator

Re: Oracle 8i import problem [message #247638 is a reply to message #247635]

Tue, 26 June 2007 11:14

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

once i was doing the imp i didnt mention the user name by default it imports all tables in system schema.Although the export dump was taken using oracle user.

Now if the same situation happened to him and data size is more then the space in system tablespace and AUTOEXTEND IS OFF
As we usually see with our UNDO tablespace.

Report message to a moderator

Previous Topic:	Cross platform export
Next Topic:	control file enhancement in sql loader.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 10:58:22 CDT 2024