Oracle Sql Developer Recyclebin

I wondered yesterday what does this means and why do i have there many “objects” (tables mostly).

Well, it’s simple.

Oracle keeps in the recycle bin information about all dropped objects. 

What ? what's for ?

Oracle keeps this information for “just in case” we will need to recover the table the index whatever.

Which is actually means that the quote space won’t be decreased as result of a drop and will still be count until we will specifically do purge to this data for the recycle bin.

You can see what’s inside your recycle bin using “select * from recyclebin”;

If you want you can read more about it here http://docs.oracle.com/cd/B28359_01/server.111/b28310/tables011.htm.

Since most of don’t have DBA privileges, this “PURGE RECYCLEBIN;” will delete only our recyclebin.

If you ask me, I think that this option should be enabled (the recycle bin) only in production, other places like development shouldn’t have this kind of fallback backup.

Hoped it helped understanding.

Dor

javax.el.ELException: The identifier [public] is not a valid Java identifier as required by section 1.19 of the EL specification (Identifier ::= Java language identifier). This check can be disabled by setting the system property org.apache.el.parser.SKIP_IDENTIFIER_CHECK to true.

Had this lately

javax.el.ELException: The identifier [public] is not a valid Java identifier as required by section 1.19 of the EL specification (Identifier ::= Java language identifier). This check can be disabled by setting the system property org.apache.el.parser.SKIP_IDENTIFIER_CHECK to true.
org.apache.el.parser.AstDotSuffix.setImage(AstDotSuffix.java:46)
org.apache.el.parser.ELParser.DotSuffix(ELParser.java:1069)
org.apache.el.parser.ELParser.ValueSuffix(ELParser.java:1035)
org.apache.el.parser.ELParser.Value(ELParser.java:980)
org.apache.el.parser.ELParser.Unary(ELParser.java:950)
org.apache.el.parser.ELParser.Multiplication(ELParser.java:714)
org.apache.el.parser.ELParser.Math(ELParser.java:634)
org.apache.el.parser.ELParser.Compare(ELParser.java:446)
org.apache.el.parser.ELParser.Equality(ELParser.java:340)
org.apache.el.parser.ELParser.And(ELParser.java:284)
org.apache.el.parser.ELParser.Or(ELParser.java:228)
org.apache.el.parser.ELParser.Choice(ELParser.java:185)
org.apache.el.parser.ELParser.Expression(ELParser.java:177)
org.apache.el.parser.ELParser.NonLiteral(ELParser.java:1183)
org.apache.el.parser.ELParser.ValuePrefix(ELParser.java:1019)
org.apache.el.parser.ELParser.Value(ELParser.java:968)
org.apache.el.parser.ELParser.Unary(ELParser.java:950)
org.apache.el.parser.ELParser.Multiplication(ELParser.java:714)
org.apache.el.parser.ELParser.Math(ELParser.java:634)
org.apache.el.parser.ELParser.Compare(ELParser.java:446)
org.apache.el.parser.ELParser.Equality(ELParser.java:340)
org.apache.el.parser.ELParser.And(ELParser.java:284)
org.apache.el.parser.ELParser.Or(ELParser.java:228)
org.apache.el.parser.ELParser.Choice(ELParser.java:185)
org.apache.el.parser.ELParser.Expression(ELParser.java:177)
org.apache.el.parser.ELParser.NonLiteral(ELParser.java:1183)
org.apache.el.parser.ELParser.ValuePrefix(ELParser.java:1019)
org.apache.el.parser.ELParser.Value(ELParser.java:968)
org.apache.el.parser.ELParser.Unary(ELParser.java:950)


Solution for me was easy and simple
Adding this to the vm arguments
-Dorg.apache.el.parser.SKIP_IDENTIFIER_CHECK=true