Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving a table
On Tue, 31 Mar 1998 19:47:05 GMT, jurij.modic_at_mf.sigov.mail.si (Jurij Modic) wrote:
Ooops, I forgot the essential step in my previous posting - to drop the old table after exporting it.
>You don't have to create a new user, synonym etc, to acomplish this.
>You can do it this way:
>1. Export a table
1.a Drop the table
>2. Create new_tablespace
....[SNIP]....
Regards,
Jurij Modic Republic of Slovenia jurij.modic_at_mf.sigov.mail.si Ministry of Finance ============================================================The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Mar 31 1998 - 00:00:00 CST