Re: Moving tables from tablespace

Dave Bornstein wrote:
>
> The easiest way I know if is the following:
>
> 1. connect to oracle as user2, and create the table in TS2.
> 2. grant insert on 'table' to ts1;
> 3. connect to oracle as ts1
> 4. insert into ts2.[tablename].test1 select * from [tablename];
> 5. revoke insert on [tablename] from user1;
>
> This is the easiest way of the table is not too complicated. use the
> describe command to see the layout of the table. Keep in mind, there
> may be constraints on the original table. If there are, you are better
> off using the export idea.

You can also try:

create table table2 as select * from table1;

Tim

-- 
+---------------------------------------------------------------+ 
|Timothy E. Taylor			Oracle Government       | 
|Staff Sales Consultant			3 Bethesda Metro Center | 
|Internet: ttaylor_at_us.oracle.com	Suite 1400              | 
|Office:   301-907-2395			Bethesda, MD 20814     	| 
|Fax:	   301-657-0037                                    	| 
+---------------------------------------------------------------+ 
| They teach you to fix what needs to be broke (P.W., 1993)	| 
+---------------------------------------------------------------+