Re: Moving tables from tablespace

Patrick Coulier wrote:
>
> Dear Oracle-newsgroupreaders,
>
> As an Oracle-newbee,
>
> this seems to be the place to ask my simple question:
>
> What's the easiest way to move a table from user USER1 and tablespace TS1 to
> another user USER2 and tablespace TS2 ???
>
> Any help is very appreciated.
>
> Pat

Export the table from USER1.
Ensure USER2 has quota on TS2 and NOT TS1. Import table into USER2 schema

Michael

###################################################################
# Michael Abbey           Ottawa ON Canada      613 780 2364
#
# Co-author of:   Tuning Oracle          Oracle: A Beginner's Guide
#                 Oracle Data Warehousing
###################################################################