Home » RDBMS Server » Server Utilities » Problem with tablespace at the time of import
Problem with tablespace at the time of import [message #136269] Wed, 07 September 2005 03:40 Go to next message
Avra
Messages: 65
Registered: July 2004
Member
Hi,

This is Avra from India... I am using Oracle8i with Win 2000 Prof... I am facing a problem at the time of import of a .dmp file into oracle... The error log file is attached with this mail... I think that I am making some mistake at the time of creation of tablespace "PLS"... The size of the .dmp file is 1.18GB... Pls give me the excast syntax of table space creation for this...So pls help me to solve the problem....


Thanks in advance.....


Avra
  • Attachment: pls_out.log
    (Size: 2.59KB, Downloaded 1067 times)

Report message to a moderator

Re: Problem with tablespace at the time of import [message #136298 is a reply to message #136269] Wed, 07 September 2005 07:59 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
when take an export always use COMPRESS=N.
and increase the size of your tablespace ( add more datafiles or extend the current datafile size).

Report message to a moderator

Previous Topic: "field in datafile exceeds maximum length" for number field
Next Topic: Exp/Imp Problem - Urgent Thanks Plz
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 22:56:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.