Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SYS can not select a table

ivwviMar 14 2016 — edited Mar 19 2016

Dear Experts,

I have imported using impdp.

But after successful import. I can not see the data.

Even sys can not select

SQL> /

OBJECT_NAME OWNER

-------------------------------------------------------------------------------------------------------------------------------- ------------------------------

VCOL_FUNCTION VCOL_TEST

VCOL_TABLE VCOL_TEST

VCOL_TABLE VCOL_TEST2

VCOL_FUNCTION VCOL_TEST2

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE 11.2.0.4.0 Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production

SQL> show user

USER is "SYS"

SQL> select * from VCOL_TEST2.VCOL_TABLE;

select * from VCOL_TEST2.VCOL_TABLE

ERROR at line 1:

ORA-01031: insufficient privileges

SQL> select * from VCOL_TEST.VCOL_TABLE;

ID VCOL

---------- ----------

1 1

2 1

11 10

12 10

SQL> sho user

USER is "SYS"

SQL>

This post has been answered by ivwvi on Mar 19 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2016

Added on Mar 14 2016

#general-database-discussions

6 comments

1,279 views