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
>
> -----Original Message-----
> From: Irfan Ahmad [mailto:[Email address protected]
> Sent: 30 August 2007 13:05
> To: Michael Peel
> Subject: Re: Tablespace is showing empty
>
> check again ::
>
> 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;
>
>
> ALTER USER HEADO QUOTA 0K ON TBS_HEADO;
>
>
> Thanks & Regard
>
> Irfan Ahmad
>
> ----- Original Message -----
> From: "Michael Peel" <[Email address protected]
> To: "'Irfan Ahmad'" <[Email address protected]
> Sent: Thursday, August 30, 2007 4:45 PM
> Subject: RE: Tablespace is showing empty
>
>
>> Just the table you tell it to move.
>>
>> I have just done a test here with the import method I suggested and it
>> worked no problem.
>>
>> Show me everything you did.
>>
>> Michael Peel
>>
>> -----Original Message-----
>> From: Irfan Ahmad [mailto:[Email address protected]
>> Sent: 30 August 2007 12:39
>> To: Michael Peel
>> Subject: Re: Tablespace is showing empty
>>
>> yes
>> i have done as per yr instructions but same response. anymore
>> suggestions.
>>
>> If apply moving command then it will moved all objects or suggest table ?
>>
>> irfan ahmad
>>
>> ----- Original Message -----
>> From: "Michael Peel " <[Email address protected]
>> To: <[Email address protected]
>> Sent: Thursday, August 30, 2007 4:26 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
>>>
>>>
>>> Alter the user so it has no quota on the system tablespace.
>>>
>>> Your best bet is to drop the user, create the user with the following
>>> line
>>> added to the creation script
>>>
>>> quota 0k on SYSTEM
>>>
>>> This means the user cannot create any objects in the system tablespace.
>>> Any
>>> objects will now be created in the default tablespace.
>>>
>>> You could also move the tables and rebuild the indexes
>>>
>>> alter table <table_name> move <new_tablesace>;
>>> alter index >index_name> rebuild tablespace <new_tablesace>;
>>>
>>> Michael Peel
>>>
>>> Michael Peel
>>>
>>> -----Original Message-----
>>> From: Irfan Ahmad
>>> [Email address protected]
>>> Sent: 30 August 2007 11:51
>>> To: LazyDBA Discussion
>>> Subject: Re: Tablespace is showing empty
>>>
>>> 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
>>>> **********************************************************************
>>>>
>>>>
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> 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
>>> **********************************************************************
>>>
>>>
>>
>> **********************************************************************
>> 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
>> **********************************************************************
>
> **********************************************************************
> 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