User Tools

Site Tools


techprivate:powerschool:customfieldsoracle

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
techprivate:powerschool:customfieldsoracle [2015/08/25 10:55]
afrink [Backups]
techprivate:powerschool:customfieldsoracle [2017/07/25 08:16] (current)
afrink [Backups]
Line 30: Line 30:
  
 <​code>​ <​code>​
 +> sqlplus / as sysdba
 +SYS@PSPRODDB AS SYSDBA> shutdown immediate
 +SYS@PSPRODDB AS SYSDBA> startup
 +
 c:​\oracle\scripts DropSchema.bat PSPRODDB c:​\oracle\scripts DropSchema.bat PSPRODDB
 c:​\oracle\scripts Import.bat PSPRODDB [dumpfilename] Y c:​\oracle\scripts Import.bat PSPRODDB [dumpfilename] Y
Line 36: Line 40:
 //Note: '​Y'​ in the import will clear settings, useful if copying data over to the test server.// //Note: '​Y'​ in the import will clear settings, useful if copying data over to the test server.//
  
-If you get a "​can'​t drop user PS" error, make sure all of the PS services ​are stopped and restart the Oracle instance with the following:+//Note: The sqlplus steps insure that all users/​connections ​are not in use. Seems to be necessary most times, so worth doing every time.// 
 + 
  
-<​code>​ 
-> sqlplus / as sysdba 
-SYS@PSPRODDB AS SYSDBA> shutdown immediate 
-SYS@PSPRODDB AS SYSDBA> startup 
-</​code>​ 
 ===== Useful SQL ===== ===== Useful SQL =====
  
techprivate/powerschool/customfieldsoracle.txt · Last modified: 2017/07/25 08:16 by afrink