79800

79800



Dropping a Table

For thc purpose of lcarning about Flashback Drop, you will crcatc a ncw table named reg_histand then drop it. The database places the table in the recycle bin so that it can be retricvcd with thc Flashback Drop featurc.

To create and then drop a table:

1.    Connect SQL*Plus to the hrschema.

Notę: For a table to be recovcrablc using Flashback Drop, it must reside in a locally managed tablespace. Also, you cannot recover tables in the SYSTEM tablespaces with Flashback Drop, regardless of thc tablespace type.

Performing User-Directed Recovery Performing Backup and Recovery 9-37

2.    Create table reg_histbased on the existing REGIONS table in the hrschema by using the fol łowi ng command:

CREATE TABLE reg_hist as SELECT * FROM REGIONS;

3.    Drop the reg_histtable using the following command:

DROP TABLE REG_HIST;

Because Flashback is enabled for the database, the dropped table is stored in the recycle bin.

4.    Display the tables in the hrschema.

SELECT * FROM TAB;

TNAME TABTYPE CLUSTERID

BIN$ANbliLHaSiu02xI+zbvDvQ==$0 TABLE

COUNTRIES TABLE

DEPARTMENTS TABLE

EMPLOYEES TABLE

EMP_DETAILS_VIEW VIEW

JOBS TABLE

JOB_HISTORY TABLE

LOCATIONS TABLE

REGIONS TABLE

9 rows selected.

The first namc displayed in the command output. beginning with ’BIN\ is thc table that you just dropped. Because Flashback Database is enabled, the deleted table is still in the recycle bin and is therefore displayed in the command output.



Wyszukiwarka

Podobne podstrony:
Fast Recovery Area To simplify thc managemcnt of backup and recovery filcs, you can crcatc a fast re
m231 Mould for thc ‘Seal of Raymond dc Mondragon I2th cen tury. Here a knight from the Rh
28 United Nations — Treaty Series1972 2.    For the purposes of this Schedule : (a)
KIF97 split rings. and shuttle 2 for thc WWT of elit*    . 1fl
image003 Want to write for IA’sfm? Please send for thc description of our needs first; write us for
6 (255) Fig. 4.7 Schcmata for thc formalion of Mississippi Vallcy-typc dcposits. (a) Chcrprcssurcd,
1933 League of Nałions — Treaty Series. 113 For the purposes of this clause, the actual expense
28 United Nations — Treaty Series1972 2.    For the purposes of this Schedule : (a)
Definition of ibfile set To avoid confusion, for the purposes of this discussion we define the term
m231 Mould for thc ‘Seal of Raymond dc Mondragon I2th cen tury. Here a knight from the Rh
79355 m231 Mould for thc ‘Seal of Raymond dc Mondragon I2th cen tury. Here a knight from
- 3 -i^7 1 obviously to undermine confidence in the present Goyemment ,for the purpose of preparing
1 (178) Strona 39 z 46 Spy Circuits We needrYt say any morę about construction as you will obvious!y
025633df1c56fef6 TT203(B)WITH LOVE CUSHION Thank you for purchosing this Cross Stitch Kit. We hope y
For these reasons, thc present Siudy was aimed at understanding thc effect of decodcr accuracy and k

więcej podobnych podstron