OraFAQ Forum: SQL & PL/SQL » how to copy a table

Home » SQL & PL/SQL » SQL & PL/SQL » how to copy a table

Thu, 07 November 2002 07:40

Gurdeep Singh
Messages: 64
Registered: October 2002

Member

please tell me how to copy a table from one user account to another user account if both are on same data base / if both are on diff database

Thu, 07 November 2002 09:43

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

create table t as select * from other_user.t;
 
create table t as select * from other_user.t@other_db;

Previous Topic:	how can i change the column name from particular table
Next Topic:	How we use these in sql

Goto Forum:

]

Current Time: Mon Apr 29 05:43:09 CDT 2024