问题
创建表到SYS用户下面导出报错
oerr ora 39166
39166, 00000, "Object %s was not found."
// *Cause: If exporting or importing over the network, either the user
// specified an object name that was not found in the source database
// or else the user lacked the proper EXP_FULL_DATABASE or
// IMP_FULL_DATABASE role that would allow them to access the object
// another in another schema. For importing from files, the user
// specified an object name not found in the dump file set.
// *Action: Retry the operation using the correct object name.
oerr ora 31655
31655, 00000, "no data or metadata objects selected for job"
// *Cause: After the job parameters and filters were applied,
// the job specified by the user did not reference any objects.
// *Action: Verify that the mode of the job specified objects to be moved.
// For command line clients, verify that the INCLUDE, EXCLUDE and
// CONTENT parameters were correctly set. For DBMS_DATAPUMP API
// users, verify that the metadata filters, data filters, and
// parameters that were supplied on the job were correctly set.
解决方案
创建一个用户导出
create user jk identified by jk;
grant dba to jk;
conn jk/jk
expdp \'sys/sys as sysdba\' DIRECTORY=DATA DUMPFILE=20220614.dmp =20220614.log TABLES=JK.GASH, JK.OBJ,JK.SQLSTAT