Re: create a table

Do you have the privilege for that table? If not, that user may grant the privilege on
that table to you. Try with this command to verify if you have the privilege:

    desc another_user.table_name;

Regards.

jlk wrote:

> I have a strange problem as below:
>
> I want to create a table which is same as another user's table so, I use
> create table mytable as select * from another_username.table_name.
> the sql sever gives me an error message as:
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
> The table does exist in the other user's account.
>
> And, I created a number of table by using above statement, it worked fine.
> Only this particulary table doesn't work. Do I miss something ?
>
> many thanks.....
Received on Tue Mar 31 1998 - 00:00:00 CST