He had an export which contained all the user objects, but in the system
schema.
So drop the user and recreate with a specified default tablespace. Then give
a 0k quota on system to the new user. This means he can create no objects in
the system tablespace. Now, when you do the import, the objects cannot be
created in system, so are created in the default that you defined.

Michael Peel

-----Original Message-----
From: David NGUYEN
[mailto:oracledba-ezmlmshield-x60511331.[Email address protected]
Sent: 31 August 2007 13:39
To: LazyDBA Discussion
Subject: RE: Tablespace is showing empty

please explain, how can you do that..?
the user(schema) is created on SYSTEM tablespace on database and you impor


it on target database with the tablespace naming TBS_HEADO on the
user(schema) HEADO.
On your database target where the objects are now..? on tbs_heado
tablespace i suppose...
how can you do that with only "alter user heado quota ok on system"
command.

thanks
david...


oracledba-ezmlmshield-x21619983.[Email address protected]
30/08/2007 14:38


Pour : [Email address protected]
cc :
Objet : Re: Tablespace is showing empty


thanks!!!! every one.. now the problem have solved..

SQL> CREATE USER HEADO IDENTIFIED BY RM
2 DEFAULT TABLESPACE TBS_HEADO
3 QUOTA UNLIMITED ON TBS_HEADO
4 TEMPORARY TABLESPACE TEMP
5 QUOTA UNLIMITED ON TEMP;

User created.

SQL>
SQL> ALTER USER HEADO QUOTA 0K ON SYSTEM;

User altered.

SQL> GRANT CONNECT,IMP_FULL_DATABASE TO HEADO; (that was the problem)

thanks again

Irfan Ahmad

----- Original Message -----
From: "Michael Peel" <[Email address protected]
To: "'Irfan Ahmad'" <[Email address protected]
Sent: Thursday, August 30, 2007 5:16 PM
Subject: RE: Tablespace is showing empty


> ALTER USER HEADO QUOTA 0K ON TBS_HEADO; should be
> ALTER USER HEADO QUOTA 0K ON SYSTEM;
>
>
> Michael Peel


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


**********************************************************************
This e-mail is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it
and do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ

AccuRead Limited Registered Number: 3076187 England
GSL UK Limited Registered Number: 3333860 England
Global Solutions Limited Registered Number: 3189802 England
**********************************************************************


Oracle LazyDBA home page