Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Copy table data from one schema to another scheman
lz2001jhu_at_yahoo.com (L1) wrote:
>Doggy Daddy <spamhole_at_nospam.org> wrote in message news:<pan.2003.04.14.15.01.19.466406.15885_at_nospam.org>...
>> On Mon, 14 Apr 2003 12:34:52 -0700, L1 wrote:
>>
>> > Hello All,
>> >
>> > wonder if you know a simple way (sql, or plsql) to copy table data from
>> > one schema to another schema for temporary achival purpose.
>> >
>> > thanks,
>> > l1
>>
>> Grant SELECT on the table to the archive schema, then connect to the
>> archive schema and CREATE TABLE archivetable AS SELECT * FROM
>> oldschema.tablename.
>>
>> You could also EXPORT the table, then IMPORT it into another schema (or
>> just keep the export file for your archive), but you said you wanted a SQL
>> or PL/SQL solution.
>
>
>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?
>
>Thanks,
>l1
Yes..as mentioned, export the Schema A tables ( export in user mode) and import into Schema B ( using the fromuser=SchemaA touser=SchemaB method)
----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Tue Apr 15 2003 - 08:45:41 CDT