Oracle SQL*Plus^TM Commands - R

Under construction

Use this command to initiate media recovery on a database, tablespace, or datafile. You must be connected as SYSDBA, SYSOPER, or INTERNAL.

RECOVER [DATABASE [[UNTIL]

              {CANCEL

              | CHANGE system_change_number

              | TIME date_time}

              USING BACKUP CONTROLFILE]

              PARALLEL([DEGREE {num_of_procs | DEFAULT

              | INSTANCES {num_of_inst | DEFAULT}]...)

              | NOPARALLEL ] |

RECOVER TABLESPACE tablespace_name

              [,tablespace_name...]

              PARALLEL([DEGREE {num_of_procs | DEFAULT

              | INSTANCES {num_of_inst | DEFAULT}]...)

              | NOPARALLEL ] |

RECOVER DATAFILE datafile_name

              [,datafile_name...]

              PARALLEL([DEGREE {num_of_procs | DEFAULT

              | INSTANCES {num_of_inst | DEFAULT}]...)

              | NOPARALLEL]

Back to top

Use this command to place comments in a SQL*Plus script.

REM[ARK] comment_text

Back to top

Use this command to define a report footer, to be printed on the last page of a report after the last detail line, and before the bottom line.

REPF[OOTER] [OFF | ON] |

              [COL x | S[KIP] x | TAB x | LE[FT] |

                 CE[NTER] | R[IGHT] | BOLD |

                 FOR[MAT] format_spec | text | variable...]

Back to top

Use this command to define a report header, to be printed on the first page of a report after the page title, and before the first detail line.

REPH[EADER] [OFF | ON] |

              [COL x | S[KIP] x | TAB x | LE[FT] |

                 CE[NTER] | R[IGHT] | BOLD |

                 FOR[MAT] format_spec | text | variable...]

Back to top

Use this command to display and execute the command in the SQL buffer.

R[UN]

Back to top     Back to Index     Home     Serious Stuff

© 2001. Copyright Sue Nethercott.