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

Oracle LazyDBA home page