Creating a Recycle Bin table in 10g

I am using Oracle 10g on a Red Hat Linux machine, and I need to create a Recycle Bin table. Ideally, I would like to create a new table and then drop it. Can you please tell me the syntax needed? Thanks.

    Requires Free Membership to View

    Login

Simply drop the table as follows: 
DROP TABLE my_table;
When you drop a table in an Oracle 10g database, it will automatically go into the Recycle Bin. There is no additional action needed on your part.

This was first published in October 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top