Home » RDBMS Server » Backup & Recovery » Import Problem - Oracle 9.2.0.6.0 on Solaris 5.8
Import Problem - Oracle 9.2.0.6.0 on Solaris 5.8 [message #143978] Mon, 24 October 2005 09:07 Go to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Hi,
i am using oracle 9.2.0.6.0 on Solaris 5.8
i am having 2 databases on the same server.
Db01 and Db02
i wanted to import a schema "schema1" from db01 to db02
before starting import, i created the user for schema2, created tablespace, granted quota etc.
however i forgot to make the newly created tablespace default for the new user.
and started import.
now object started creating in 'SYSTEM' TABLESPACE.
almost 70% tables created and the tablespace became full.
almost no space left in the datafile.
the import stall there.
i resized the existing datafile as well as added one more datafile to the tablespace.
however the import is still stalling.
please suggest.

Thanks in Advance,
Pratap
Re: Import Problem - Oracle 9.2.0.6.0 on Solaris 5.8 [message #143982 is a reply to message #143978] Mon, 24 October 2005 09:22 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>however the import is still stalling.
Kill the job. Startover. That is easiest thing to do ( in the target database, remove all the objects created by import for the new user).
And do not give the resource role to the new user.
It allows the user to create objects in any tablespace.
Make the tablespace as default and allocate quota.
First make sure the source tables are not in system tablespace.


Previous Topic: I need help how to recover my database
Next Topic: recover a table from an rman backup
Goto Forum:
  


Current Time: Thu Mar 28 16:44:43 CDT 2024