If I accidentally clear the data in the tuser table in ORACLE, how can I restore the previous data?

select * from user_recyclebin where original_name='tuser';

If you have this table, you can.

flashback table tuser to before drop;

Are you deleted * from tuser empty?

Or is it truncate table tuser emptied?

If it is deleted * from tuser.

With Oracle Flashback Query technology, you can get it back with a bit of luck.

Oracle Flashback Query Example:

Locate the backed up data for recovery.

Oracle DBA: PRM-DUL disaster recovery tool and schema-level data recovery. PRM-DULFOR Oracle Database Schema-level Oracle Database Data Recovery Manager, or ParnassusData Recovery Manager, is an enterprise-level Oracle database disaster recovery tool.

PRM can restore truncated tables without backup, and can also restore data in Oracle databases that cannot be opened (alter database open failed).

select * from store_record as of timestamp sysdate-1/24/60*40;

The default time of flashback is very short.

sysdate-1 is the day before.

You cut it down and see.

commit? If the archive is not opened, you can try it with flashback query.

The first method is to delete table A and copy table A1 to table A.

The second method: execute the following two statements successively: truncate table a;

insert into a select * from a1

The easiest way is to delete table A, and then use PLSQL to rename table A1 to A.

1. First, create a new test table and enter records in it. Since the deletion of the Update insertion recovery steps is the same, here only the case of deleting the data is demonstrated.

2. Delete 1 of the records and check the records in the table, as you can see from the figure below, record 2 has been deleted.

3. Before restoring, determine the time point to be restored, as can be seen in the figure below, the data of 2018-03-07 15:33:00 is correct.

select *

from test as of timestamp to_timestamp('2018-03-07 15:33:00', 'yyyy-mm-dd hh24:mi:ss');

4. Perform table data recovery below.

flashback table test to timestamp to_timestamp('2018-03-07 15:33:00', 'yyyy-mm-dd hh24:

mi:ss');

You can see that an error is reported, and the reason is that the line movement is not enabled.

5. Turn on the row movement of the table.

alter table test enable row movement;

6. Perform data recovery again.

flashback table test to timestamp to_timestamp('2018-03-07 15:33:00', 'yyyy-mm-dd hh24:

mi:ss');

Then check the data and you can see that it has been restored.

--Turn on the row movement function.

alter table name enable row movement;

Restore table data.

flashback table name to timestamp to timestamp(.'2014-05-19 09:40:00','yyyy-mm-dd hh24:

mi:ss');

The above time is the time when the data is deleted.

Note: Please turn off the row movement function after restoration.

1. Find your data from 10 days ago (if your data is still available) create table tmp as

select * from table_name as of timestamp trunc(sysdate)-10;

2. Find the 100 pieces of data that you deleted in the TMP table and insert them back into the original table.

3. But I don't have much hope, I see that your question has been raised for a long time, and if it has just been deleted, it may be able to be retrieved.

Note: trunc(sysdate)-10 is a point in time, you can adjust this point in time to find the data you want.

- Above, I hope it helps you.

How many oracles are you using?

If it's more than 10 versions, it's easy to say, and if it's 92, you have to find it from undo.

select * from tablename as of timestamp

to_timestamp('2010-12-15 11:10:17', 'yyyy-mm-dd hh:mi:ss')

If it's 91 or 8, it's trouble!!

If it is deleted shortly, you can use a flashback query, for example, from table1 to query the records of one day ago.

select * from table1 as of timestamp sysdate-1;

Is there a wood to open a flashback, archive?

If there is a flashback, it can be recovered with the following statement:

flashback table table_name to timestamp systimestamp-1;

systimestamp-1 here indicates a return to the previous day).

Use Flashback, Oracle 10G and above!

You can use truncate or delete, for example, if you want to empty a table named abc, write sql:

truncate table abc;Or:

delete from abc;

Oracle checks the version number, how to check the version of Oracle, the specific steps are as follows:

2. Method 1: v$version

sql> select * from v$version;

3. Method 2: Product Component Versionsql> select * from Product Component Version;

truncate table table_name；

Operation characteristics: truncate only deletes all data in the table, but does not delete the structure of the table.

Truncate and Delete should both meet your requirements.

It's just that the latter still has room to return, while the former cannot.

truncate table tablename;

Deletes all data in the table.

--Turn on the row movement function.

alter table name enable row movement;

Restore table data.

flashback table name to timestamp to timestamp(.'2014-05-19 09:40:00','yyyy-mm-dd hh24:

mi:ss');

The above time is the time when the data is deleted.

Note: Please turn off the row movement function after restoration.

Oracle DBA: PRM disaster recovery tool for schema-level data recovery. PRM for Oracle Database Schema-level Oracle Database Data Recovery Manager, or ParnassusData Recovery Manager, is an enterprise-level Oracle database disaster recovery tool.

PRM can restore tables that have been truncated and dropped without backup, or restore data in Oracle databases that cannot be opened (Alter Database Open failed). PRM is a graphical enhancement to Oracle DUL that has many features that Oracle DUL does not have.

artifact: select * from exzlhzsfsjb as of timestamp sysdate-1 24;

Explanation: as of timestamp sysdate-1 24, query the data in the table at the point in time from the current date to 1 hour ago.

You can also use subtraction directly to query the missing parts of two result sets (data that existed 1 hour ago and does not exist now).

select * from exzlhzsfsjb as of timestamp sysdate-1/24

minusselect * from exzlhzsfsjb;

Insert into ...select ..Can.

This method does not apply with too long a period of time because your Oracle flashback zone space is limited.

Other oracle questions can be found on my blog.

1. Enter in cmd.

sqlplus / as sysdba

2. Delete all the data associated with User A and User A.

drop user a cascade;

3. Rebuild user A

create user a identified by password;

grant connect,resource to a;

4. Log in to user A, and it's OK.

conn a password.

- Meaning, I hope it helps you.

Connect to the system user first: conn as sysdba and then delete the user: drop user username cascade; --Cascade to delete all data and objects under the user.

Finally, reconstruct the user: create user username identified by password;

Grant permissions: grant connect, resource to username;

If it's still in the trash, you can go in and restore it, and if you clean up the trash, you can execute: 1. Click "Start - Run", and then enter regedit (open the registry).

2. In order: hekey - local - machime software microsoft windows currentversion explorer desktop namespace Click "New" outside the left blank

Select: "Primary Key" and name it "645ffo40 - 5081 - 101b - 9f08 - 00aa002f954e".

Then set the key value of the "default" primary key on the right to "**site", and then exit the registry. That's it.

3. Restart the computer.

As long as the machine has not run defragmentation. The system is intact. Documents can be retrieved at any time.