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.
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.
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.
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.