altdb_misc.gif

alter database DBS-NAME 
 {
  reset [{all|data}]
  |force restructure
  |load alias_table ALT-NAME-SINGLE from data_file FILE-NAME
  |unload alias_table ALT-NAME-SINGLE
  |add variable VARIABLE-NAME [STRING]
  |drop variable VARIABLE-NAME
  |delete lro 
   {
    all
    |by USER-NAME
    |before DATE
    |by USER-NAME before DATE
   }
  |unlock all objects
  |begin archive to file FILE-NAME
  |end archive
  |[force] archive to file FILE-NAME
  |[force] restore from file FILE-NAME
  |replay transactions 
   {
    after LOG-TIME
    |using sequence_id_range ID-RANGE
   }
  |rename to DBS-STRING
  |comment COMMENT-STRING
 }