关于dbms_backup_restore.setDatafileAux

Maclean Liu(刘相兵

关于dbms_backup_restore.setDatafileAux


setDatafileAux这个过程是为数据文件设置一个辅助文件名，不会影响使用的。

AUX_NAME        VARCHAR2(513)        Auxiliary name that has been set for this file via CONFIGURE AUXNAME



PROCEDURE setDatafileAux( dfnumber  IN  binary_integer
                           ,fname     IN  varchar2 DEFAULT NULL);

  -- setDbfileAux sets auxilary filename.
  --
  -- Input parameters:
  --   dfnumber
  --     Data file number of a file to alter. This refers to the file that
  --     is currently accessible via SQL commands.
  --   fname
  --     Name of the file to be set as auxfilename.
  --
  -- Exceptions:
  --   DATABASE-NOT-MOUNTED (ora-1507)
  --     The database is not mounted.
  --   NAME-TOO-LONG (ora-19704)
  --     The specified name is longer than the port-specific
  --     maximum file name length.
  --   FILE-IN-USE (ora-19584)
  --     The specified output file is already in use by the database as a
  --     datafile, online redo log or auxname for some other file.