dbTalk Databases Forums  

Copy 10 table

comp.database.oracle comp.database.oracle


Discuss Copy 10 table in the comp.database.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Wallace
 
Posts: n/a

Default Copy 10 table - 04-13-2005 , 03:17 AM






How Can I duplicate 10 table with record and index with a single script?
What is the code?
Thanks




Reply With Quote
  #2  
Old   
bdj
 
Posts: n/a

Default Re: Copy 10 table - 04-13-2005 , 11:42 AM






Hi!
Do you want to copy tables?
1.) solution a
create table newtab1 as select * from tab1;
create table newtab2 as select * from tab2;
create index....
.....

2.) solution b
imp(ort)/exp(ort)

/Bjørn


"Wallace" <nospam (AT) nospamtin (DOT) it> skrev i en meddelelse
news:d3ikl4$qpo$1 (AT) area (DOT) cu.mi.it...
Quote:
How Can I duplicate 10 table with record and index with a single script?
What is the code?
Thanks






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.