home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a523 / 17.ddi / ORAINST.SQL < prev    next >
Encoding:
Text File  |  1990-11-02  |  461 b   |  20 lines

  1. startup
  2. connect internal
  3.  
  4. alter tablespace system
  5. add datafile '%ORACLE_HOME%\DBS\DBS2.ORA' size 1M;
  6.  
  7. alter tablespace users
  8. add datafile '%ORACLE_HOME%\DBS\USERS2.ORA' size 1M;
  9.  
  10. alter database oracle close;
  11.  
  12. alter database oracle
  13. rename file 'DBS1.ORA','USERS1.ORA','LOG1.ORA','LOG2.ORA'
  14. to '%ORACLE_HOME%\DBS\DBS1.ORA','%ORACLE_HOME%\DBS\USERS1.ORA',
  15.    '%ORACLE_HOME%\DBS\LOG1.ORA','%ORACLE_HOME%\DBS\LOG2.ORA';
  16.  
  17. disconnect
  18. shutdown
  19. exit
  20.