After I import a dump file into Oracle DB, I got this successful message.
Master table “SYS”.”SYS_IMPORT_FULL_01″ successfully loaded/unloaded import done in AL32UTF8 character set and AL16UTF16 NCHAR character set export done in WE8ISO8859P15 character set and AL16UTF16 NCHAR character set Warning: possible data loss in character set conversions Starting “SYS”.”SYS_IMPORT_FULL_01″: sys/******** AS SYSDBA full=Y directory=TEST_DIR dumpfile=exp_tbs_gxplt01282019.dmp logfile=impdpDB10G.log Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/TABLE_DATA . . imported “XPL”.”ARTICLE_USAGE_TEMP” 642.3 MB 5270266 rows Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER Job “SYS”.”SYS_IMPORT_FULL_01″ successfully completed at Mon Feb 4 22:18:37 2019 elapsed 0 00:00:21
But when I tried to get access to the table, using
select * from ARTICLE_USAGE_TEMP;
ORA-00942: table or view does not exist
Is there any permission I should open to access the table?