I am a junior oracle dba. I know this is one is easy for you all.
Just wanted to know whether we can exclude the tables, which we dont want to have the import of?
I mean, i have a dump file *.dmp by export script on production db. I have copied the dump file to our development db. There are almost 300 tables in the *.dmp file and i want to exclude some 20 to 25 tables from the dump file. Is it possible to using any EXCLUDE parameter in the import scrip that would exclude the tables. Our db is oracle 9i.