answersLogoWhite

0

How do you restore a table deleted from oracle 10g?

Updated: 8/19/2019
User Avatar

Wiki User

13y ago

Best Answer

If you are on 10g or later and the recycle bin feature is turned on, you can use the FLASHBACK TABLE x TO BEFORE DROP command, where x is the name of the table. If it is not there, or the recycle bin feature is not available, you will have to restore the table from a backup.

User Avatar

Wiki User

13y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you restore a table deleted from oracle 10g?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is all about oracle 10g and oracle8i?

The oracle 10g and oracle 8i there is a minor difference that is oracle 8i doesn't support flash back command once we drop the table in database the message is table dropped but we can use flashback command we can retrieve the drop table once in database


How to import Data from .txt file to oracle 10g table?

Use SQLLoader utility of Oracle


Where can one find the Oracle 10g documentation?

There are many companies and websites that offer the oracle 10g documentation. The best way to obtain the Oracle 10g documentation is through the official Oracle website.


Full form of 10g in oracle?

the full form of 10g in oracle is g=grid computing


Why is Oracle 10g named so?

In Oracle 10g, 'g' stands for grid computing. For more details about Oracle 10g and overall Oracle DB please refer the following link:http://en.wikipedia.org/wiki/Oracle_Database


What are the common Linux commands by Oracle 10g?

Oracle 10g's commands are internal; they have nothing to do with what platform it is running on.


What does selection means in oracle 10g?

get data of particular rows from the table. Criteria can be used to select the rows retrived


What is the full form of oracle 9i?

what is difference between oracle 9i and oracle 10g what is difference between oracle 9i and oracle 10g What is the Full form of "i" in Oracle 9i What is the Full form of "g" in Oracle 10g ans =the oracle 9i the "i" is stands for internet and oracle 10g the " g" stands for grid and new version of oracle 11g was launch in 2007 it provided the special feature rather 8i ,9i other it have a RAC, and network security etc. and good for organization purpose .


Where can one download the oracle client 10g?

Go to Oracle's webpage for a free download of Oracle 10g for Windows 7, and every other software need you have from Oracle! Oracle will help solve all your software needs!


What is the meaning of g in oracle 10g?

G signifies "Grid Computing"... With the release of Oracle 10g in 2003, Oracle changed the suffix in their previous release version; from 9i to 10g... 'I' stands for Internet...this was done as a marketing effort in order to show Oracle's move towards Grid Computing... Purely a marketing strategy...


Host string in oracle 10G?

oracleDB


You are lookig for oracle forms 10g books?

there is no books in oracle forms 10g in oracle publication but they have student Gide which is not good for certification exam u should try Otn forums for help......