Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Duplicate Tables with indexs

Re: Duplicate Tables with indexs

From: daniellopez21 <daniellopez21_at_gmail.com>
Date: 19 Oct 2005 07:48:54 -0700
Message-ID: <1129733334.121175.158380@o13g2000cwo.googlegroups.com> 





But, i want duplicate tables and indexes, with others names. For
example : "table2" "index2" etc



With


"SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name)  FROM USER_TABLES
u; " the table name of scripts are equal of table name of BBDD.



Yes, i don't a good english :p กก
Received on Wed Oct 19 2005 - 09:48:54 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US