http://tsinglee.itpub.net 人力:只需要你在工作中肯卖力气就足够了;人手:则需要你熟悉掌握工作，能应付突发事件;人才:则需要你头脑灵活，能够在工作中提出创造性的方案;人物:就需要八面玲珑，用自己特有的方式为公司做出比较大的贡献. http://tsinglee.itpub.net/post/33707/466728 Thu,17 07 2008 11:24:38 1)prior放在子节点端,则表示扫描树是以start with指定的节点作为根节点从上往下扫描.可能对应一个或多个分支.start with可以省略,如果省略,表示对所有节点都当成根节点分别进行遍历.2)prior放在父节点端,则表示扫描树是以start with指定的节点作为最低层子节点,从下往上扫描.顺序是子节点往父节点扫描,直到根节点为止,这种情况只能得到一个分支.start with可以省略,如果省略,表示对所有节点都当成最低层子节点分别往根节点方向遍历. http://tsinglee.itpub.net/post/33707/466727 Thu,17 07 2008 11:23:56 The DBMS_OUTLN and DBMS_OUTLN_EDIT package provides procedures used for managing stored outlines and their outline categories. Users need the EXECUTE_CATALOG_ROLE role to execute DBMS_OUTLN, but public has execute privileges on DBMS_OUTLN_EDIT. The DBMS_OUTLN_EDIT package is an invoker's rights package.Some of the useful DBMS_OUTLN and DBMS_OUTLN_EDIT procedures are:■ CLEAR_USED - Clears specified outline■ DROP_BY_CAT - Drops outlines that belong to a specified category■ UPDATE_BY_CAT - Chang... http://tsinglee.itpub.net/post/33707/466651 Wed,16 07 2008 14:09:45 catalog.sql - create data dictionary views.cataudit.sql - data dictionary views for auditing. (catnoaud.sql will remove)catblock.sql - create views of oracle lockscatclust.sql - create cluster database specific views definitionscatdbsyn.sql - catalog dba synonyms (dba_synonyms.sql)catexp7.sql - create v7 style export/import viewscatexp81.sql - create internal views for export/import utilitycatio.sql - collect i/o per table/object stats by statistical samplingcatjava.sql - catalog scripts for jav... http://tsinglee.itpub.net/post/33707/466539 Tue,15 07 2008 10:40:38 Question: I'm creating a new database manually and I don't know all of the data dictionary scripts that I need to run. I know that I need to run catalog.sql and catproc.sql, but what other data dictionary scripts are required?Answer: The answer depends on what options that you are installing. Also note that some scripts have sub-scripts, and catalog.sql calls other scripts within the $ORACLE_HOME/rdbms/admin directory. Here are the sub-scripts within catalog.sql: * catadt.sql - Creates views tha... http://tsinglee.itpub.net/post/33707/466537 Tue,15 07 2008 10:39:42 SQL*Plus uses the PRODUCT_USER_PROFILE (PUP) table, a table in the SYSTEM account, to provide product-level security that supplements the user-level security provided by the SQL GRANT and REVOKE commands and user roles.DBAs can use the PUP table to disable certain SQL and SQL*Plus commands in the SQL*Plus environment on a per-user basis. SQL*Plus—not Oracle Database—enforces this security. DBAs can even restrict access to the GRANT, REVOKE, and SET ROLE commands to control users' ability to ch... http://tsinglee.itpub.net/post/33707/466538 Tue,15 07 2008 10:39:16 RMAN automatically backs up the current server parameter file in certain cases. The BACKUP SPFILE command backs up the parameter file explicitly. For example:BACKUP DEVICE TYPE sbt SPFILE;The SPFILE that is backed up is the one currently in use by the instance. If the instance is started with a client-side initialization parameter file, then RMAN does not back up anything when this command is used. http://tsinglee.itpub.net/post/33707/463773 Thu,05 06 2008 10:52:41 You can back up the control file when the database is mounted or open. RMAN uses a snapshot control file to ensure a read-consistent version. If CONFIGURE CONTROLFILE AUTOBACKUP is ON (by default it is OFF), then RMAN automatically backs up the control file and server parameter file after every backup and after database structural changes. The control file autobackup contains metadata about the previous backup, which is crucial for disaster recovery.If the autobackup feature is not set, then you... http://tsinglee.itpub.net/post/33707/463772 Thu,05 06 2008 10:51:42 You can backup one or more individual tablespaces with the BACKUP TABLESPACE command. You can use this command when the database is mounted or open.To back up a tablespace:After starting RMAN, run the BACKUP TABLESPACE command at the RMAN prompt. This example backs up the users and tools tablespaces to tape, using the MAXSETSIZE parameter to specify that no backup set should be greater than 10 MB:BACKUP DEVICE TYPE sbt MAXSETSIZE = 10M TABLESPACE users, tools;Oracle translates the tablespace nam... http://tsinglee.itpub.net/post/33707/463771 Thu,05 06 2008 10:48:17 You can perform whole database backups with the database mounted or open. To perform a whole database backup, from the RMAN prompt, use the BACKUP DATABASE command. The simplest form of the command requires no parameters, as shown in this example:RMAN> BACKUP DATABASE;This example shows the procedure for taking a whole database backup to the default destination:RMAN> BACKUP DATABASE; # uses automatic channels to make backupRMAN> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; # switches logs and archive... http://tsinglee.itpub.net/post/33707/463769 Thu,05 06 2008 10:43:23