Re: tough questions for Data selection!!! ..(HELP!!!)

Just moving 100 rows from each table wont work. There will be refrences to fixed application sequences/values, and foreign keys and more - pointing into blue air. Except if you have a dogme database that dont use constraints, indexes and other fancy stuff. I am working on a freeware project that can pick up all constraints and references for one 'key' row and move all interconnected data to a test database. But it still lacks some polishing and fixing. Please wait ...

/Svend Jensen

JK Yao wrote:

> 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:20:01 CDT