Join | Login | Why Join?

Access to 501 free guest articles, discussions and more, just create your free SSWUG User ID:

Email address:

This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.

Email to Friend // Discuss Article // Rate Article // Digg Article // Add to Del.icio.us // Add to Technorati

Full site membership is required for this article. Already a full member? Login here.
You currently have a guest membership. You can upgrade to full site membership here (free trial available).

Recycle Bin in Oracle Database 10g

Article Abstract:

(Yuli Vasiliev) Normally, in Oracle Database, when you drop all the object tables that are based on an object type, you can then drop that object type. In Oracle 10g, by default, all dropped tables along with their dependent objects like indexes, constraints etc. are placed in the recycle bin. This means that you can restore a dropped table if necessary. However, if you drop all the object tables based on an object type, and then you drop that object type, you won’t be able to restore any of these tables.

Read this article...

Related Articles - For Members.

	All Articles By Author
	Second Normal Form (2NF)
	SQL Server 6.5: Some useful undocumented DBCC commands
	SQL Server 2000 useful undocumented stored procedures
	Undo The Past ---Use FlashBack Technology with Oracle Database 10g
	Meta Data User-Defined Functions
	Automate Database Defragmentation and Statistics Updates
	SQL Server 7.0 useful undocumented stored procedures
	Rolling Window, Grouping Tables and More
	Temporary Tables: Declared and Created
	Split Comma Separated Data Into A Table

Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

Reader Comments: Post Your Comments/Feedback

RE: Recycle Bin in Oracle Database 10g
(posted: 8/24/2004 2:45:11 PM)
should i expect the "purge" command to fail when accessing an oracle 10g database server using sql+ from an oracle 9.2 remote client?

RE: Recycle Bin in Oracle Database 10g
(posted: 11/25/2004 5:44:59 AM)
I didn't manage to access an oracle 10g database server using SQLPlus from an oracle 9.2 remote client. Maybe it is possible but additional steps are needed to make it work.

Email to Friend // Discuss Article // Rate Article // Digg Article // Add to Del.icio.us // Add to Technorati

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc. (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004

		*Search* SSWUG: