| Import Problem - Oracle 9.2.0.6.0 on Solaris 5.8 [message #143978] |
Mon, 24 October 2005 09:07  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
