SQL*Plus Quick Reference Release 8.1.5 A66735-01 |
|
SQL*Plus Quick Reference, 8 of 10
ARCHIVE LOG {LIST|STOP}|{START|NEXT|ALL|
integer
} [TO
destination
]
DESC[RIBE] [
schema
.]
object
[@
net_service_name
]
RECOVER [AUTOMATIC][FROM
location
]
{[STANDBY] DATABASE [UNTIL
options
][USING BACKUP CONTROLFILE]
|TABLESPACE {
tablespace
[,
tablespace
...]}
|DATAFILE {
datafilename
[,
datafilename
...]}
|STANDBY {TABLESPACE
tablespace
[,
tablespace
...]
|DATAFILE
datafilename
[,
datafilename
...]}
UNTIL CONTROLFILE
|LOGFILE
filename
|CONTINUE [DEFAULT]
|CANCEL}
[PARALLEL
clause
]
{CANCEL|CHANGE integer|TIME date}
and where clause requires the following syntax:
{PARALLEL ([DEGREE {integer|DEFAULT}
|INSTANCES {integer|DEFAULT}]...)
|NOPARALLEL}
Performs media recovery on one or more tablespaces, one or more datafiles, or the entire database.
SET
system_variable value
APPI[NFO]{ON|OFF|text} ARRAY[SIZE] {15|n} AUTO[COMMIT] {OFF|ON|IMM[EDIATE]|n} AUTOP[RINT] {OFF|ON} AUTORECOVERY {ON|OFF] AUTOT[RACE] {OFF|ON|TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]] BLO[CKTERMINATOR] {.|c} CMDS[EP] {;|c|OFF|ON} COLSEP {_|text} COM[PATIBILITY] {V7|V8|NATIVE} CON[CAT] {.|c|OFF|ON} COPYC[OMMIT] {0|n} COPYTYPECHECK {OFF|ON} DEF[INE] {'&'|c|OFF|ON} DESCRIBE [DEPTH {1|n|ALL}][LINENUM {ON|OFF}][INDENT {ON|OFF}] ECHO {OFF|ON} EDITF[ILE] file_name[.ext] EMB[EDDED] {OFF|ON} ESC[APE] {\|c|OFF|ON} FEED[BACK] {6|n|OFF|ON} FLAGGER {OFF|ENTRY|INTERMED[IATE]|FULL} FLU[SH] {OFF|ON} HEA[DING] {OFF|ON} HEADS[EP] {||c|OFF|ON} INSTANCE [instance_path|LOCAL] LIN[ESIZE] {80|n} LOBOF[FSET] {n|1} LOGSOURCE [pathname] LONG {80|n} LONGC[HUNKSIZE] {80|n} NEWP[AGE] {1|n|NONE} NULL text NUMF[ORMAT] format NUM[WIDTH] {10|n} PAGES[IZE] {24|n} PAU[SE] {OFF|ON|text} RECSEP {WR[APPED]|EA[CH]|OFF} RECSEPCHAR {_|c} SERVEROUT[PUT] {OFF|ON} [SIZE n] [FOR[MAT] {WRA[PPED]| WOR[D_WRAPPED]|TRU[NCATED]}] SHIFT[INOUT] {VIS[IBLE]|INV[ISIBLE]} SHOW[MODE] {OFF|ON} SQLBL[ANKLINES] {ON|OFF} SQLC[ASE] {MIX[ED]|LO[WER]|UP[PER]} SQLCO[NTINUE] {> |text} SQLN[UMBER] {OFF|ON} SQLPRE[FIX] {#|c} SQLP[ROMPT] {SQL>|text} SQLT[ERMINATOR] {;|c|OFF|ON} SUF[FIX] {SQL|text} TAB {OFF|ON} TERM[OUT] {OFF|ON} TI[ME] {OFF|ON} TIMI[NG] {OFF|ON} TRIM[OUT] {OFF|ON} TRIMS[POOL] {ON|OFF} UND[ERLINE] {-|c|ON|OFF} VER[IFY] {OFF|ON} WRA[P] {OFF|ON}
SHO[W] [
option
]
system_variable ALL BTI[TLE] DESCRIBE ERR[ORS] [{FUNCTION|PROCEDURE|PACKAGE|PACKAGE BODY| TRIGGER|VIEW|TYPE|TYPE BODY} [schema.]name] LNO PARAMETERS [parameter_name] PNO REL[EASE] REPF[OOTER] REPH[EADER] SGA SPOO[L] SQLCODE TTI[TLE] USER
Enter any system variable set by the SET command in place of system_variable.
|
Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|