There are 2479 total tables...So it is difficult to do import by specifying table names. Is there any way to exclude tables. i.e. Can i give only those table names which i want to exclude....that will be easy for me.
With Regards
Sudhanshu Kulshreshtha
Software Consultant
Hi Guys,
I have one export (.exp) file of Oracle 8.0 It has around 1000 tables and indexes etc. Out of 1000 tables there are few tables that have rows in millions.
Is there any way to import the file without data of the heavy tables? More specifically my mean is "Can i exclude these heavy...
You have to write these functions
1.CheckAnyChild()
2.DeleteAnyChild()
3.DeleteParent()
You have to call these functions in a procedure and in a loop by checking if conditions.
I hope this will solve your problem.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.