drop table

Hi BBAs

I had a lot of temp tables in my major user.
When I droped all temp tables from the user,only one table has not droped.

Error says: table or view does not exist.

But I could see the table in my user and dba_usrs table.

What could be a problem.. please help me.

Thanx in advance.

RTM

What is RTM.

Can you explain this.Please..............

read the manual, sometimes referred to as read the flipping manual :-)

Quote:

---

Originally posted by sri_dba
Hi BBAs

I had a lot of temp tables in my major user.
When I droped all temp tables from the user,only one table has not droped.

Error says: table or view does not exist.

But I could see the table in my user and dba_usrs table.

What could be a problem.. please help me.

Thanx in advance.

---

Thank gawd i am not a BBA :-)

Quote:

---

Originally posted by hrishy
Thank gawd i am not a BBA :-)

---

Hrishy :

I guess you are in one of your :D:D phase?

Abhay.

Get the table name from dba_tables, then

drop table "table name";

Quote:

---

Originally posted by xyz2000
Get the table name from dba_tables, then

drop table "table name";

---

Be careful with this!!

In my environments there are duplicate table names under different schemas. If you fail to specify the OWNER in the drop statement, you will drop whichever table has the public synonym, sometimes this can be (Elmer Fudd voice) vewy vewy bad, heh heh heh.

Always use the OWNER.TABLENAME just to be safe.

MH

Quote:

---

Originally posted by Mr.Hanky
If you fail to specify the OWNER in the drop statement, you will drop whichever table has the public synonym, sometimes this can be (Elmer Fudd voice) vewy vewy bad, heh heh heh.

MH

---

Absolute Crap...DDL always needs Owner.Object_Name, if not then it will do DDL on schema logged in and not using the public synonym which might be pointing to any other schema's object.

PS below

Code:

---

TEST:ABHAY> ed
Wrote file afiedt.buf

  1* create table x(key number)
TEST:ABHAY> /

Table created.

TEST:ABHAY> create public synonym x for x;

Synonym created.

TEST:ABHAY> grant create table to test;

Grant succeeded.

TEST:ABHAY> conn test/test
Connected.
TEST:ABHAY> drop table x;
drop table x
          *
ERROR at line 1:
ORA-00942: table or view does not exist

TEST:ABHAY> create table x(key number);

Table created.

TEST:ABHAY> drop table x;

Table dropped.

TEST:ABHAY> desc x
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- --------
 KEY                                                            NUMBER

TEST:ABHAY> desc abhay.x
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- --------
 KEY                                                            NUMBER

---

Did it drop using public synonym???

Abhay.

YOU ARE ABSOLUETLY RIGHT!!

My bad, I don't know what I was thinking.
It is still a good practice to specify the owner,table_name though.

MH