Home » RDBMS Server » Server Utilities » Oracle 8i import problem
icon8.gif  Oracle 8i import problem [message #247491] Tue, 26 June 2007 02:18 Go to next message
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
Re: Oracle 8i import problem [message #247496 is a reply to message #247491] Tue, 26 June 2007 02:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
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

Re: Oracle 8i import problem [message #247626 is a reply to message #247496] Tue, 26 June 2007 10:39 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Use fromuser touser clause for import.
Re: Oracle 8i import problem [message #247635 is a reply to message #247626] Tue, 26 June 2007 11:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How is this solving the error problem?

Regards
Michel
Re: Oracle 8i import problem [message #247638 is a reply to message #247635] Tue, 26 June 2007 11:14 Go to previous message
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.
Previous Topic: Cross platform export
Next Topic: control file enhancement in sql loader.
Goto Forum:
  


Current Time: Mon Dec 05 08:52:55 CST 2016

Total time taken to generate the page: 0.21270 seconds