Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tough questions for Data selection!!! ..(HELP!!!)
Replication or a standy by is your best bet, otherwise You have to
write a script to do it manually or by interperting/manipulating the
V$, DBA_, and various other system tables
j
jkyf0131_at_hotmail.com (JK Yao) 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 - 14:47:18 CDT