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;

ERROR:

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

FROM DUAL

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.