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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > > 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 > > > > [EMAIL PROTECTED] To: Multiple > recipients of > > list ORACLE-L <[EMAIL PROTECTED]> > > Sent by: cc: > > > > [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > > > 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: [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). > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > 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: [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!? 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: [EMAIL PROTECTED] 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: [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).
