By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.
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.