Re: cannot see tables

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Tue, 03 Jul 2001 07:04:23 GMT
Message-ID: <3B4170CA.63264063@telusplanet.net>

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