hi Michael Peel
Yes, this user was exist in Systems tablespace now i want to import into
tbs_heado tablespace. But i cant enable to understand your suggestions.

irfan ahmad
----- Original Message -----
From: "Michael Peel " <[Email address protected]
To: <[Email address protected]
Sent: Thursday, August 30, 2007 3:48 PM
Subject: RE: Tablespace is showing empty


> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email,
> **and removed any attachments, and kept your email address secret
> **from this person, and any viruses/trojans.
> **If you reply to this email, the person will see your email address as
> normal
> **Anything below this line is the original email text
>
>
> 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
> [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