|
|
| |
 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 8 -
Miscellaneous Oracle Information
Using PUPBLD
-
PL/SQL commands - BEGIN, DECLARE
-
SQL*PLUS reads restrictions from product_user_profile when a user logs on using SQL*PLUS and
maintains those restrictions for the duration of the session. To
disable a SQL or SQL*PLUS command for a given user, insert a row
containing the user's username in the USERID column, the command
name in the ATTRIBUTE column, and DISABLED in the CHAR_VALUE column.
Copying databases
between servers
Don't use the EXPORT/IMPORT utility to copy
databases between servers running the same operating system. Execute
the following steps to speed the transfer:
-
Execute the ALTER DATABASE BACKUP CONTROLFILE
TO TRACE statement on the source server.
-
Bring the database down and copy the trace
file, parameter file, all datafiles, control files and redo logs to
the new server.
-
Edit the trace file to change the database name
if you need to (also change the REUSE keyword to SET), change
NORESETLOGS to RESETLOGS, change directory names if they have
changed, delete all comments and lines that have a # in front of
them (they aren't comments in all tools).
-
Connect internal and run the SQL statement
contained in the trace file. It will start up the database in
NOMOUNT stage and recreate the control files. The script will then
MOUNT and OPEN the database.
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. |
|
|
|
