Table name with funny characters

[mankrish]

RDBMS Version: 10g Enterprise Edition Release 10.1.0.2.0

Hi,

This is my first experience creating a database on 10g. I tested first by creating a test table and I dropped the table immediately after creating. Next I proceeded to create the actual table (section) and it was successful. When I did a check on the user_tables this is what I get (a table_name with multiple characters) just below the section table,

SQL> select table_name from user_tables;

TABLE_NAME
------------------------------
SECTION
BIN$CHcMxT2qRmOuePUzHW8BcQ==$0

I never created them and I am wondering what this is. Is something wrong somewhere? How do I remove that? Why does this happen?

Appreciate any advice.

Thanks.

[Thomasps]

lol...... Read about recyclebin - new feature in 10g..!

[vnktummala]

Hi Mankrish:

Unless until you delete the table using 'DROP TABLE SECTION PURGE' , the dropped table will go and resides in the recycle bin with system generated name. When you issue 'select table_name from user_tables' that table will also list in the resultset.

Issue 'PURGE RECYCLEBIN' from your SQL prompt then issue the same command 'select table_name from user_tables' then you will find the difference.

Thank you,

-Vijay.

[marist89]

I see you like spamming the forums.