I assume that you are referring to data that does not belong in
the system tablespace, like that of another user ?
If so, make sure "that user" has their default tablespace set
for their own tablespace (use ALTER USER ..., to fix it). The
(re)CREATE newtable as select * from oldtable' the table(s)
{using different names} so they will go in the correct
tablespace. DROP tables that are in the old tablespace. RENAME
the tables.
- Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!
Received on Tue Feb 08 2000 - 14:16:50 CST
