Question: I have all of the DDL
for my schema in some DDL files and I wonder where Oracle
says to store the .sql files. In will need to be able
to find these .sql files if I ever need to re-create mu
schema tables and indexes.
Answer No, you don't need to keep
the DDL .sql files because they are stored in the data
dictionary and they are accessible via the
However, most DBA's keep a personal library of .sql
scripts and I made a personal directory in the
$ORACLE_HOME/dba directory to save my SQL*Plus scripts..
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.