Hi,
Did the data that was exported exist in a different tablespace that exists
in the database you are importing to? If it did, then the objects will be
created in the original tablespace in your target db.
You can get around this by giving a quota of 0k on the original tablespace
to your user and importing again. (after dropping the imported objects or
the user).
Michael Peel
-----Original Message-----
From: Irfan Ahmad
[mailto:oracledba-ezmlmshield-x47411157.[Email address protected]
Sent: 30 August 2007 11:38
To: LazyDBA Discussion
Subject: Tablespace is showing empty
hi everyone
I am creating a tablespace and assigning to a user. and after that import
data into this user but when i try to see tablespace consumption through OEM
its showing me blank. suggest me ...
Statements are :::::
CREATE TABLESPACE TBS_HEADO
DATAFILE 'D:\oracle\oradata\pharmax\TBS_HEADO.DMP' SIZE 1024M
CREATE USER HEADO IDENTIFIED BY RM
DEFAULT TABLESPACE TBS_HEADO
QUOTA UNLIMITED ON TBS_HEADO
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON TEMP;
GRANT CONNECT,CREATE SESSION,RESOURCE TO HEADO;
Thanks & Regard
Irfan Ahmad
---------------------------------------------------------------------
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