Oracle will first attempt to create the table in the tablespace that it
was exported from, if that tablespace exists and the user has quota on
that tablespace.
In addition to altering scott's default tablespace, you need to do
alter user scott quota 0 on users;
then do the import and make scott's default tablespace users again and
give the account quota on users.
- Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa> wrote:
> hi...
>
> can you give the exact steps for ur 2nd option.
>
> 1)exp scott/tiger tables=emp,
> 2)alter user scott default tablespace tools,(before it's users)
> 3)imp scott/tiger fromuser=scott touser=scott
>
> But still oracle imports to users tablespace itself.
> i made users tablespace off, before import, that case, i kicked away
> by an
> error, as tablepsace is in offline.
>
> Expecting your answer.
>
> Rgds,
> Nirmal.,
>
> > -----Original Message-----
> > From: G.Plivna_at_itsystems.lv [SMTP:G.Plivna_at_itsystems.lv]
> > Sent: Thursday, October 25, 2001 3:25 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Move table to another tablespace
> >
> >
> > above 8.<something>
> > alter table <table_name> move tablespace <tablespace_name>;
> >
> > Or always you can
> > 1. export table
> > 2. recreate in another tablespace
> > 3. import data in table created in step 2.
> >
> > Gints Plivna
> > IT Sistēmas, Merķeļa 13, LV1050 Rīga
> > http://www.itsystems.lv/gints/
> >
> >
> >
> >
> >
> > Roland.Skoldbl
> >
> > om_at_ica.se To: Multiple
> recipients of
> > list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Sent by: cc:
> >
> > root_at_fatcity.c Subject: Move table to
> > another tablespace
> > om
> >
> >
> >
> >
> >
> > 2001.10.25
> >
> > 13:00
> >
> > Please respond
> >
> > to ORACLE-L
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Hallo,
> >
> > Can you please tell how to move one table from one tablespace to
> another?
> > I
> > have data inthistable.
> >
> > Thanks in advance
> >
> > Roland Sköldblom
> >
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: Roland.Skoldblom_at_ica.se
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing
> Lists
> >
> --------------------------------------------------------------------
> > 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).
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: G.Plivna_at_itsystems.lv
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing
> Lists
> >
> --------------------------------------------------------------------
> > 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Thu Oct 25 2001 - 08:53:24 CDT
