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

On Wed, 14 Oct 1998 16:47:50 -0500, "Randal Chapman" <Randalc_at_corprasoft.com> wrote:
Hello Randol,
Could you select the table after exported it from access by connect CLDSYS?
One time I exported a table from access to oracle but the table name in access is lowercase(emp) not uppercase(EMP). after exported I couldn't find the EMP table. (select * from emp; --> object not exist) So I exported again and with table name uppercase(EMP) then I could do:select * from emp;
Hope this help.

Violin.

>Hi group.
>
>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?
>
>Thanks,
>
>_Randal
>
Received on Wed Oct 14 1998 - 20:40:33 CDT