I think the point was he didn't want to have 5000+ lines (for the 5000+
tables) doing this. However, I suppose you could use dynamic SQL to allow a
PL/SQL script to dynamically generate the create statements below using
DBA_TABLES.
In article <9n83g4$psq$1_at_newsreaderm1.core.theplanet.net>, "Alistair Thomson"
<thomson_alistair_at_yahoo.co.uk> wrote:
>Hi
>
>Well you could set up a database link between the two databases and have a
>script which runs something like:
>
>create tablea as select * from tablea_at_remotedblink where rownum <101;
>create tableb as select * from tableb_at_remotedblink where rownum <101;
>create tablec as select * from tablec_at_remotedblink where rownum <101;
>create tabled as select * from tabled_at_remotedblink where rownum <101;
>
>Wont work if you have long datatypes (not sure about blobs and clobs)
>
>Alistair
>
>JK Yao <jkyf0131_at_hotmail.com> wrote in message
>news:93f65984.0109052344.4b7cb3cc_at_posting.google.com...
>> dear all,
>>
>> Presume that I have a production database A and test database B
>> Is there any script or any way to create a database B as database A?
>> But I only want partial data from each table. I have 5000+ tables in
>> database A, so it's impossible to do it one by one. Say I need first
>> 100 rows of data of each table of database A and copy to database B.
>> Is that possible?
>>
>> Please clarify. Thanks a lot.
>>
>> I use Oracle8.1.6 in Solaris2.6
>>
>> regards,
>> JK
>
>
Received on Thu Sep 06 2001 - 10:34:06 CDT
