Fulltext results:
- Oracle: SPFile and PFiles
- ile instead of ${PATH_TO_PFILE}. <code sql> SHUTDOWN IMMEDIATE; STARTUP NOMOUNT PFILE='${PATH_TO_PFILE}' CREATE SPFILE FROM PFILE; SHUTDOWN IMMEDIATE; </code> If your PFile is located at '... ore inforamtion, see the documentation: [[http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams054.htm#REFRN10235|10.2]] [[http://download.oracle.com/docs/cd/E11882_01/server.112/e1082
- Oracle: List Accounts with Objects
- can query them with: <code sql> SELECT DISTINCT OWNER FROM DBA_OBJECTS ORDER BY OWNER; </code> If you want to list all accounts, you can query them with:
- Oracle Errors
- recovery area]]. * **Documentation**: [[http://download.oracle.com/docs/cd/B19306_01/server.102/b14219/e0.htm#sthref181|10.2]] [[http://download.oracle.com/docs/cd/E11882_01/server.112/e1088
- Oracle: EXP
- bash> exp USERID=\'/ as sysdba\' FILE={user}.dmp FULL=N OWNER={user} </code> {{tag>admin exp oracle}}
- Oracle: Resize Instance
- instance to activate the change: <code sql> SHUTDOWN IMMEDIATE; STARTUP; </code> {{tag>admin oracle}}