Archive

Let’s assume you’re using EXP, not EXPDP to backup your tables (I still have some Oracle 9i databases). You have schema with about 1000 tables, and the list can change. There is one table that is huge, and you don’t need to export this or one of this table is corrupted, DBMS_REPAIR doesn’t work and you want the full export without this one table. This is what you can do:

1. Assume that user you use to export is SYSTEM (of course you can use other user name).

2. Create function (SYS AS SYSDBA) that returns condition that is false when user is SYSTEM: