Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: question on imp and exp

Re: question on imp and exp

From: raju pa <raju_pa_24_at_yahoo.com>
Date: Fri, 15 Aug 2003 16:29:23 -0800
Message-ID: <F001.005CAF5A.20030815162923@fatcity.com>


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" <jinchen_at_ufl.edu> 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: jinchen_at_ufl.edu

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: ListGuru_at_fatcity.com (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!
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: raju pa
  INET: raju_pa_24_at_yahoo.com
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: ListGuru_at_fatcity.com (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). Received on Fri Aug 15 2003 - 19:29:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US