What is Oracle BBED Tool? How to make it Available in Oracle 11g?

BBED: Block Browser and Edit Tool
It is an Oracle tool to check the internal structure of the Oracle blocks. You have to use this tool very carefully as it can damage the Oracle blocks as well as the Oracle database too. This tool allows editing the blocks of the datafiles and it overrides the oracle access.

How to Recover / Restore / Recreate Dropped Dual Table in Oracle? ORA-01775: looping chain of synonyms

DUAL table is owned by SYS schema and it can be dropped only by a DBA user. As a DBA you are not supposed to drop the DUAL table as it will affect the database badly. In case if the DUAL table gets dropped by mistake, you can follow below steps to recover the DUAL table and the database operations.

Difference between BIGFILE and SMALLFILE tablespace, Advantages. How to Create and Resize Bigfile Tablespace?

There are 2 kinds of tablespace allowed. One is traditional tablespace which is known as SMALLFILE tablespace and the second one is the BIGFILE tablespace. For bigfile tablespace we should consider with ASM or other logical volume managers that support dynamically extensible logical volumes and striping or RAID.

Select from System Package DBMS_METADATA Failed: ORA-25153: Temporary Tablespace is Empty, ORA-06512

Error Description:
Select from system packages getting failed with following error
SQL> select dbms_metadata.get_ddl ('TABLE', 'DUAL','SYS') from dual;
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.DBMS_METADATA", line 4018

Insert, Delete, Truncate Operations with Oracle Dual Table. Just Not Fun

Don’t play with dual table in an active database. Really it is not fun.
Insert Row in Dual
If you insert a row into dual, it will not list in the select command. But if you try to create a dummy table from the dual it will show the actual content of the dual table.

How to Query / Generate Multiple Rows from Oracle DUAL Table?

Method 1: Using Connect By Clause

Number Series from DUAL
SQL> SELECT rownum
CONNECT BY rownum <= 10;

Siebel Database Configuration Failed: C102: The Username / Password Combination.00000: cannot be validated at this

Error Description:
Siebel database configuration failed with following error message.
Enter a valid ODBC (Open Database Connectivity) Data Source Name to access the
Siebel Database connection. Default value is Siebel_DSN.

How to Check What is Getting / Being Audited in Oracle Database?

Below mentioned 3 data dictionary views can be used to fetch the details of the auditing.
  1. dba_obj_audit_opts: Data dictionary view will give the details of auditing options on all objects. user_obj_audit_opts view will provide the details of the auditing enabled

Will Oracle Unique Key Constraint Allow / Accept more than One NULL Value?

What is Unique Key Constraint?
Unique key is one of the 5 integrity constraints. Oracle Unique key can be the combination of one or more than one (upto 32) columns. This key ensures the data uniqueness for the columns specified in the key. Which means the same combination cannot be repeated for a specified unique key.

crontab Commands Fails in Linux: You (%s) are not allowed to use this program (crontab)

Error Description:
crontab –e, crontab –l commands are failing with following error.
$ crontab -l
You (brmsftp) are not allowed to use this program (crontab)
See crontab(1) for more information
$ crontab -e

STOP / Disable Oracle 11g ADDM, AWR using control_management_pack_access Parameter

You can stop the ADDM in Oracle 11g using control_management_pack_access initialization parameter. The values permitted for this parameter are
  1. NONE – Both packs are not available
  2. TUNING – Only tuning packs (SQL Tuning advisor, SQLAccess Advisor) are avilable

How to Change / Move Oracle Inventory Location to another Directory?

Step 1. Find out the oraInst.loc file location either using find command or opatch utility.
$ ./opatch lsinventory
Invoking OPatch

dbms_stats.gather_table_stats : ORA-00600: internal error code, arguments: [smboPut:fixedlen2]

Error Description:
dbms_stats.gather_table_stats command fails with ORA-00600: internal error code, arguments: [smboPut:fixedlen2]
SQL> exec dbms_stats.gather_table_stats (ownname=>'xxx', TABNAME=>’YYYY’, estimate_percent=>100,cascade=>TRUE);

Oracle SQL Query to Print / Display Calendar Using 11gR2 LISTAGG Function

The input for this query is the first date of the year. It will display the calendar. Interesting one.. Try this J

SQL Query:

How to Disable / Escape / Avoid / Stop & and && Variable Substitutions in Oracle SQL Plus

Difference between & and &&
‘&’ is used to substitute values for one time to the variable. So whenever you execute the sql with & it will prompt for the variable values.

Procedure to Apply and get OCP Certificate and Logo who Completed Exams Hands on Training

I have received my OCP certificate recentlyJ. I have successfully completed my OCP certification examinations in 2009. But I was not able to attend the Hand-on course during same year. Recently I had a chance to complete the hands-on course and I applied for OCP certificates.

dba topics. Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google