| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> AW: How to move tables from one tablespace to another (Oracle 7.3
one possiblity:
Export your tables, create a you with the efault tablespace where you =
want
your tables, import the tables with this user. The user shouldn't have
quotas on the tablespace where you have exported from.
Regards
i. V. Volker Sch=F6n
INPLAN RUHR
Informationstechnik GmbH
Tel.: +49 208 / 65 91 - 950
Fax: +49 208 / 65 91 - 980
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de
=20
-----Urspr=FCngliche Nachricht-----
Von: ALEMU Abiy [mailto:abiy.alemu_at_criltechnology.com]
Gesendet am: Freitag, 28. April 2000 04:08
An: Multiple recipients of list ORACLE-L
Betreff: How to move tables from one tablespace to another (Oracle
7.3.4)
What is the easiest method to move tables from one tablespace to =
another. I
think that it's not as simple as moving indexes but I would like to =
have a
step-by-step method . Thank you in advance friends !!!
--=20
Author: ALEMU Abiy
INET: abiy.alemu_at_criltechnology.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 Fri Apr 28 2000 - 02:50:04 CDT
 |
 |