Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Can Oracle move tables cross schema without physical copying!
Hi, gurus:
I have a question for all the gurus on this group.
Can I move tables cross schemas with doing
create table target_table_name
select * from source_table_name.
Since I can't use RENAME, because I want to move it cross different schemas.
If anyone knows, could you e-mail me at tangd_at_ctcdist.com
Thanx
Dong Tang Received on Fri Jun 19 1998 - 17:35:23 CDT