Originally posted by gandolf989
exp system/passwd full=y grants=y rows=n constraints=n

imp system/passwd full=y grants=y rows=n constraints=n

Then compile the invalid objects

Code:
spool c:\my comp.sql
SELECT 'ALTER ' ||
   DECODE(object_type, 'PACKAGE BODY','PACKAGE',object_type) ||
   ' ' || owner || '.' || object_name ||
   DECODE(object_type, 'PACKAGE BODY',' COMPILE BODY;',' COMPILE;')
  FROM all_objects
 WHERE status = 'INVALID';
spool off
@c:\my comp.sql
why not just.....

DBMS_UTILITY.COMPILE_SCHEMA (
schema VARCHAR2);