Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: cannot see tables
Just as a matter of interest, check out the catalog sql scripts that exist in your rdbms/admin directory. Going from memory, the 'user' tables may deliberately exclude those owned by SYS and SYSTEM, but I'm not sure.
In any case, it is generally not a good idea to import non-Oracle created tables into user SYSTEM (nor is it a good idea to create tables in the SYSTEM tablespace). Strongly advise you move the tables to a different schema owner.
/HAns
Dave Nixon wrote:
> Hi
> I have imported 15 tables into the system user schema. When I logon to the
> databse as system/manager using the oracle odbc test i can connect ok but
> cannot see any tables when I click on 'user tables'. However if I do a query
> on a table that I know exists in the system users schema i get results.
> I can see other users tables when I logon as them..eg scott's tables are
> visible.
> Any ideas
> Dave
Received on Tue Jul 03 2001 - 02:04:23 CDT
![]() |
![]() |