Re: question on imp and exp

[raju pa]

Just one more step :

Before you import. You also have to reduce or make zero the quota of this user on 'system' tablespace. I do not know if zero works. and make sure the user does not have 'unlimited tablespace' priv implicitly or explicitly , either directly or thru a role.

 

Because when you import the objects go to the tablespace they were exported from. if that is not found etc then they go to the user's default tablespace.

 

Alternatively you can try the move command for tables. or the rebuild online for indexes.

you can also have script to create user so these steps are not missed. for that matter script for everything.

good luck.

"CHEN,JIN" <[EMAIL PROTECTED]> wrote:

I found I create a user and forgot to set tablespace. So it uses
the SYSTEM tablespace. Now I wonder if this is feasible:
1)use exp to export that schema,
2) drop schema,
3) recreate user/schema with another tablespace
4) imp data back

Can I have all data stored in the new tablespace?
Thanks,

--
CHEN,JIN


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: CHEN,JIN
INET: [EMAIL PROTECTED]

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

---

Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!