OraFAQ Forum: Server Utilities » ORA-01658 in an import

Home » RDBMS Server » Server Utilities » ORA-01658 in an import

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

ORA-01658 in an import [message #70428]

Wed, 12 June 2002 08:45

Alvaro Armenteros
Messages: 1
Registered: June 2002

Junior Member

Hello

I've an export file (full export) of a database and I'm trying to import it and I'm having the ORA-01658 error when creating some objects:there is not space in the tablespace...
I uninstalled Oracle and now I've reinstalled it and created the same tablespaces. Nothing has changed since I made the export. How is possible?

Report message to a moderator

Re: ORA-01658 in an import [message #70429 is a reply to message #70428]

Wed, 12 June 2002 09:50

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

as per docs

1) To prevent the large initial extent from being   allocated you should 
  specify COMPRESS=N during your export. 
2.) To prevent this problem you must add space to the tablespace. This can be 
  done using ALTER TABLESPACE ADD DATAFILE or 
  ALTER DATABASE DATAFILE '<file>' RESIZE <size>;.

Report message to a moderator

Previous Topic:	import segmentation fault
Next Topic:	IMP-00037: Character set marker unknown???

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 05 04:46:59 CDT 2026