Oracle8i Scripts

ORACLE8i SCRIPTS

Note: Save the script file with .SQL extension - the default extension while saving is .TXT

 
Script Name

freespace8i.sql

Purpose Information on tablespace used and free space. Oracle8i version of the freespace.sql script found under Oracle7 scripts.
Parameters None
Command Line SQL> @freespace8i 
View Script         Sample Output
 
Script Name

tsinfo8i.sql

Purpose Information on tablespace. Oracle8i version of the tsinfo.sql script found under Oracle7 scripts.
Parameters Tablespace Name
Command Line SQL> @tsinfo8i <tablespace name>
View Script         Sample Output
 
Script Name

tsall8i.sql

Purpose All information on tablespaces in the database.
Parameters None
Command Line SQL> @tsall8i 
View Script         Sample Output
 

 

Search BijooS.com Exact Match Search      
Home Oracle DBA TKMCE Alumni H1B Info Guestbook

Biju Thomas is Oracle7.3 OCP, Oracle8 OCP, 
Oracle8i OCP and Oracle9i OCA/OCP Certified DBA

Questions/Comments? Write to webmaster@bijoos.com. The scripts, tips and articles appearing on BijooS.com cannot be reproduced elsewhere without the prior permission from the webmaster.