Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tough questions for Data selection!!! ..(HELP!!!)
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:05:32 CDT