Oracle Database Discussions

Hi,

I need to export the schema and import the same to other system having same oracle version.
can I use the sys as sysdba user to export all schema's objects individually and import the same.
if no ?can you please let me know the causes.

If I created the new user what are the privileges shoud I grant him.

I created one user testdba and granted DBA privileges as well full_export_database.
after that I run catexp.sql with sys credential.
While running the schema level export using testdba I am getting the below error:


My Export scripts is

exp testdba/password FILE=ALLEDW_edw2.dmp log=ALLEDW_edw2.log owner=ALLEDW grants=y indexes=y direct=y compress=y


EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: view "TESTDBA.V_$OPTION" has errors
ORA-06512: at "SYS.DBMS_AW", line 151
ORA-06512: at "SYS.DBMS_AW_EXP", line 225
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_AW_EXP.schema_inf
o_exp
EXP-00008: ORACLE error 980 encountered
ORA-00980: synonym translation is no longer valid
ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 133
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.sc
hema_info_exp
. exporting foreign function library names for user ALLEDW
. exporting PUBLIC type synonyms

Regards,