select * from all_tables a where --a.TABLE_NAME = ‘DEPT’;
a.OWNER = ‘TIANSONG’;
CREATE TABLE DEPT_BACK AS SELECT * FROM DEPT A ;
SELECT * FROM DEPT_BACK A ;
SELECT * FROM NEW_DEPT_BACK ;
DROP TABLE DEPT_BACK;
ALTER TABLE DEPT_BACK RENAME TO NEW_DEPT_BACK ;
create table NEW_DEPT_BACK
(
deptno NUMBER(2),
dname VARCHAR2(14),
loc VARCHAR2(13),
id NUMBER(20)
);
–第一步:新建的表修改名称否则会报错
ALTER TABLE old_table_name RENAME TO new_table_name ;
–第二步:·用 Oracle Database 10g 中的闪回表特性
flashback table (被误删的表名) to before drop ;
flashback table (被误删的表名) to before drop ;