Home » RDBMS Server » Backup & Recovery » Import Error
Import Error [message #177216] Tue, 13 June 2006 08:25 Go to next message
touchedge
Messages: 1
Registered: June 2006
Location: India
Junior Member
I was using oracle 8.1.5.0.0. I used backup my data using the EXP command. My machine crashed yesterday. I once again reinstalled Oracle and tried importing my data using the IMP command. I had about 6 users in my export DUMP. I was unable to import only 4 users. When I tried the next 2 users, the system table space started to grow abnormally and it reported out of space error while importing. What should be done to import the data ?.

Report message to a moderator

Re: Import Error [message #177219 is a reply to message #177216] Tue, 13 June 2006 08:32 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> When I tried the next 2 users, the system table space started to grow abnormally
Why are these two users (and others) having system tablespace as the default tablespace?
Bad bad practise.
create a new tablespace, assign it to the user as default tablespace and allocate quota. Do not give RESOURCE role to the user. Try again.

Report message to a moderator

Previous Topic: why more redologs generated ??
Next Topic: Syntax for dump logfile options in 10g?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 19:27:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.