Is there an easy way of copying a percentage of a database to another database, keeping integrity ? I have written a process to do this, but it is a mish-mash of database packages and SQL scripts, using DB Links to pass the data. It has worked, but it is over complicated.
Any pointers greatly appreciated.
11-07-2000, 05:50 AM
hmm export/import should work
11-07-2000, 06:10 AM
I'm talking about a percentage (not 100%, that would be easy :-) ) of a relationsal database without losing database integrity and not keeping database integrity by copying data that isn't needed. If you can do that in export, then great, but I would be VERY surprised.
11-07-2000, 06:16 AM
well you just want some rows from a table or the whole table? if you want a few rows then the only way is db link
11-07-2000, 06:18 AM
I've just re-read that and it looks a bit aggressive, which it wasn't meant to be, I was just so surprised you said export/import would work.
11-07-2000, 09:01 AM
If you want it for Read-Only, an option is Standby Database.
11-07-2000, 11:03 AM
m1l, have you investigated the QUERY option of export? (it's in 8i, don't know about 8.0). It would still be a huge hassle to get a subset of data, but better than moving it via flat files, I suspect. You could at least get a group of tables in one swipe, depending on your dependencies.
Good Luck, D.
11-07-2000, 11:36 AM
You could use the COPY command in SQLPlus (look in the SQLPlus docs). It doesn't require dblinks or export/import. It allows you to copy any recordset you can think of defining in the SELECT statement clause.