Re: Help: Table doesn't belong to anything!

From: RobO <info_at_ohall.com>
Date: Thu, 15 Oct 1998 00:06:52 +0200
Message-ID: <7037dv$982$1@goof.de.uu.net>

Randal Chapman wrote in message
<908419B7607C7E25.60E2F7680270342F.B56EDF7E76179057_at_library-proxy.airnews.ne t>...
>I exported a table to Oracle from Access (yeah, yeah... anyway) to a
>tablespace named CLDSYS - which belongs to user CLDSYS.
>
>Here is my problem - the table is in there, but I cannot grant select
>priveleges on it because I can't seem to come up with a logon that can
"see"
>the table. I tried with SYS, SYSTEM, and INTERNAL, and even the CLDSYS
>logins.
>
>Is there some kind of 'Master' login that can see all objects by default?
>How do I get this table out of limbo?

SELECT TABLE_NAME,OWNER from ALL_TABLES WHERE .....

Regards
RobO Received on Wed Oct 14 1998 - 17:06:52 CDT