I just found out that we have a full export from friday night.
I will drop all 15 owner related to that datafile. And i just found out that we need only 5 owner, all other is garbage.
So i will drop, recreate that tablespace, then 5 owner import.
So no need to create test instance and all.




Reply With Quote