Joords Oracle DBA blog

Both the serial and parallel version of:    INSERT /*+ APPEND */           INTO ...     SELECT ...         FROM ... uses the same quick interface as Direct Load under some conditions. Conditions are listed in Concepts Guide. How can one to tell if direct insert feature is used or not?

I have the following information : OOO 1 2 3 --- - - -  A  X X  B  X   X  C    X X And I want this as output: 000   print ---   -----  A      1  A      2   B      1   B      3  C      2  C      3  This can be done with the following SQL statement:

Oracle CertView This exciting new tool gives Oracle Certification candidates the ability to carry out some basic functions related to their certifications on their own, reducing wait times for information and verifications. Using this interface, you will be able to:  Review your demographic information Review your certification history Download your Oracle Certification logos Review your exam history Track your success kit status Send certification verification to a 3rd party

The GRANT ANY OBJECT PRIVILEGE system privilege allows users to grant and revoke any object privilege on behalf of the object owner. This provides a convenient means for database and application administrators to grant access to objects in any schema without requiring that they connect to the schema. This eliminates the need to maintain login credentials for schema owners so that they can grant access to objects, and it reduces the number of connections required during configuration. This system privilege is part of the Oracle supplied DBA role and is thus granted (with the ADMIN OPTION) to any user connecting AS SYSDBA (user SYS). As with other system privileges, the GRANT ANY OBJECT PRIVILEGE system privilege can only be granted by a user who possesses the ADMIN OPTION. When you exercise the GRANT ANY OBJECT PRIVILEGE system privilege to grant an object privilege to a user, if you already possess the object privilege with the GRANT OPTION, then the grant is performed in the ...

The following execute commands generate a trace file from controlfile. Option 1: ALTER DATABASE BACKUP CONTROLFILE              TO TRACE AS '<file location and filename>' RESETLOGS; A script is generated with only the RESETLOG clause. Option 2: ALTER DATABASE BACKUP CONTROLFILE              TO TRACE AS '<file location and filename>' NORESETLOGS; A script is generated with only the NORESETLOG clause. Option 3: ALTER DATABASE BACKUP CONTROLFILE              TO TRACE AS '<file location and filename> '; A script is generated with both options RESETLOG and NORESETLOG clauses.