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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Copy table data from one schema to another scheman

Re: Copy table data from one schema to another scheman

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Tue, 15 Apr 2003 14:36:35 GMT
Message-ID: <3E9C17F0.99E825F4@telusplanet.net> 





L1 wrote:



> So if I have 40 tables in Schema A, and wanna copy all 40 to schema B,

> does that mean i have to write that CREATE TABLE script for each one

> of those 40 tables and bundle them in a procedure? Is there any other

> easy ways?

>




Why write it yourself?  Get tyhe system to do it for you - just write a SELECT statement against the catalog to
generate the create table scripts.
Received on Tue Apr 15 2003 - 09:36:35 CDT












Original text of this message













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