 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 8 -
Miscellaneous Oracle Information
Copy Command in SQL*PLUS
Koch and Loney describe the COPY command as
being "underutilized and unappreciated" in Oracle8I - The Complete
Reference. The COPY command copies data from one table to another in
the same or different databases. You are able to specify the columns
to be copied, commit points (prevents those pesky rollback problems
from occurring) and whether you want to append, create, insert or
replace data in the target table. If you want to safely copy small
to medium size tables between databases, try COPY.
Displaying Time in
Milliseconds
You can use dbms_utility.get_time
function to display the time in 100th of second
SELECT dbms_utility.get_time FROM dual;
!, $ and Host Command
Differences
You can execute a "!" on UNIX and a "$" on MVS,
VMS and Windows to execute operating system commands as child
processes of SQL*PLUS. You can also execute the keyword "HOST" to do
the same thing. What's the difference? "HOST" will perform variable
substitution (& and && symbols), whereas "!" and "$" will not.
Learn Command Line
BEFORE Using "Sissy GUI Tools" Like Oracle Enterprise Manager
Oracle Enterprise Manager may have a nice GUI
interface, but it won't help you if you can't execute it. What
happens when you get called at home or you don't have access to the
GUI? Learn command line FIRST and then use OEM.
The above text is
an excerpt from:
OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
Administration Techniques
ISBN 0-9744355-3-8
by Christopher T. Foot
http://www.rampant-books.com/book_2003_2_OCP_print.htm
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
