Getting back the dropped table back in ORACLE

You can get back the dropped table in ORACLE . To do so checkout FLASHBACK command.
Here is a example below :

First of all create a table.I am creating  a table with name First_Table.
"CREATE  table First_Table(name varchar(20),id varchar(10))"

Then DROP the table using DROP command like this: DROP table First_Table

And here comes the magic command to get back the dropped table:
FLASHBACK TABLE  First_Table TO BEFORE DROP;

Comments

Post a Comment

Popular posts from this blog

Arrays.sort() and Collections.sort() NullPointerException

While sorting an array by using Arrays.sort()  or using Collections.sort() for sorting a list you can encounter a NPE (NullPointerException) . You might be thinking what went wrong ? So one of element in the array which have been  passed for sorting contains the null element. Similar with the list case also .So check for a null entry in your array or list before passing to these methods as parameter. Example 1 : String[] strarr={"abc", "def" , null}; Arrays.sort(strarr); Output 1: -------- Exception in thread "main" java.lang.NullPointerException at java.lang.String.compareTo(String.java:1167) at java.lang.String.compareTo(String.java:92) at java.util.Arrays.mergeSort(Arrays.java:1144) at java.util.Arrays.sort(Arrays.java:1079) at Test.main(Test.java:7) Example 2: List strlist=new ArrayList (); strlist.add("abc"); strlist.add("def"); strlist.add(null); Collections.sort(strlist); Output 2: ---------- ...
Read more

Project facet Java 6.0 is not supported by target runtime JBoss

This problem will come due to a mismatch over the JDK version defined in the Project Facet for that particular project and the version ,the runtime server is having. This thing worked for me  . I am having Eclipse Helios and JDK 1.5 installed .Right click on the project in Eclipse ,click the properties menu, click the Project Facets.After clicking you will see in right side some listing will come and among them one entry will be for java.So click on the java property and you will be see a drop-down box .Change the version accordingly.I have changed it to 1.5 and it worked for me. Clean the project. Hope the solution works for you.....
Read more

org.xml.sax. SAXParseException: Element type "web-app" must be declared.

Sometime you will notice these kinds of error messsges while deploying your web application to Tomcat.  org.apache.commons.digester.Digester - Parse Error at line 22 column 18: Element type "web-app" must be declared. org.xml.sax.SAXParseException: Element type "web-app" must be declared. at org.apache.xerces.framework.XMLParser.reportError(XMLParser.java:1213) at org.apache.xerces.validators.common.XMLValidator.reportRecoverableXMLError(XMLValidator.java:1807) at org.apache.xerces.validators.common.XMLValidator.validateElementAndAttributes(XMLValidator.java:3633) at org.apache.xerces.validators.common.XMLValidator.callStartElement(XMLValidator.java:1229) at org.apache.xerces.framework.XMLDocumentScanner.scanElement(XMLDocumentScanner.java:1806) at org.apache.xerces.framework.XMLDocumentScanner$ContentDispatcher.dispatch(XMLDocumentScanner.java:949) at org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner.java:381) at org...
Read more