Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Export whole schema except data from 1 table?
I want to export a 10gR2 schema onto my laptop, but it has one huge
table with data I don't need. All tables are in 1 tablespace. Is there
anyway to do this without having to list the 70 other tables in a
parameter file? Or export the whole thing but only import all the rows
except from that one table?
"Unsupported" tweaking of the dump file perhaps? This would only be to copy onto a remote test system.
-- Sincerely, Michael Ray Topshot Systems LLC -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 20 2006 - 20:58:12 CDT
![]() |
![]() |