In the hint, pq_distribute, which is the outer distribution table and which is the inner distribution table?

I am now using an Access program that was created years ago and I used it 5 yrs ago and am now back - and when I attempt to go from 1 record to another with the arrows at the bottom - it use to scan very quickly and now I have to click on the arrow each time to make it go from one record to another. Is there an easy way to make that move quickly without having to click on the arrow each time?

I have some datafiles were there on a secondary disk and that disk has become damaged and new disk at this time not available. How will I recover from this situation?

thanks in advance.
Ibrahim

Hi I want to know what are thw common oracle production support issues that we face when we deal with banking domain and as general too.

What is the difference of using cursor for loop and open,fetch,close. Which one is better? Both are giving same output

Magu

• Aug 5th, 2007

Isolated join is a join which is not connected to any of the context.

Answer Question  Select Best Answer

Prashanth

• Apr 28th, 2006

is it drived ? Are you sure ..I think is is Derived.

Answer Question  Select Best Answer

In oracle we are using dual table name for the temporary purpose. which table we are using in SQL server

gheibia

 Profile Answers by gheibia Questions by gheibia

• Mar 23rd, 2006

The SELECT command'S syntax in SQL Server is different than Oracle.In SQL Server you don't need (always) to select data from a source (using FROM).you can just select a variable.What SQL Server dose i...

Answer Question  Select Best Answer

Oracledba

• May 2nd, 2006

V$backup : This status column of this view shows whether a tablespace in hot backup mode.The status 'ACTIVE'  shows the datafile to be in backup mode.V$datafile_header : The fuzzy column also hel...

Answer Question  Select Best Answer

If we create a table having a column of BLOB data type then how we have to insert and retrieve the data?

Mahim Mishra

• Jul 8th, 2006

We can Read and Write BLOB Data to a Database Table Through an Anonymous PL/SQL Block .The primary advantage of using anonymous PL/SQL blocks is improved performance -they can be used to batch a ser...

Answer Question  Select Best Answer

How to repair the tnsnames.ora file.
File is completely corrupted and you get network adapter errors and TNS resolve error after restarting the machine.

dbxplorer

 Profile Answers by dbxplorer Questions by dbxplorer

• Jul 21st, 2011

Delete or rename the older file and try to recreate it using "netmgr" using proper information of your database.

Answer Question  Select Best Answer

What is meant by Remote Backup?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

Suppose as a client u connected to server with the help of some third party tool and you are going to take backup from your server then that is called remote backup.

Answer Question  Select Best Answer

Explain in detail what are bdump, cdump & udump?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

background dump (bdump) :--. > bdump is used for all the issues raised related to background process in our database. its also contain alert .log which contain all activities and issues related to da...

Answer Question  Select Best Answer

What is the use of catalog and no catalog in RMAN?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

Rman with catalog means our target database registered in catalog and its used for recovery purpose. its containing metadata about to database.

rman with no catalog means metadata stored in controlefile through the controlfile we can do the recovery.

Answer Question  Select Best Answer

How to give private and public database links ?What is syntax for that ?What means mutation in oracle??

dbxplorer

 Profile Answers by dbxplorer Questions by dbxplorer

• Jul 21st, 2011

Database link is the pointer that allow users to access other user's object in remote database. This is one way communication path using database links. Private db links: CREATE DATABASE LINK link_na...

Answer Question  Select Best Answer

mani

• Oct 12th, 2021

Clob

Answer Question  Select Best Answer

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Sep 28th, 2007

1. Show SGA.2. It is related to block oracle has to search more.3. Increase the size of Undo segment.

Answer Question  Select Best Answer

janardhan akki

• Sep 26th, 2012

In Case of normal views when ever u call the view it will get data from base table......

in case of pipeline view: if u call the view it vil get data from another view .....means it also logically getting data from base tables only.......the inner view may be materialized view....

Answer Question  Select Best Answer

santosh Panigrahi

 Profile Answers by santosh Panigrahi Questions by santosh Panigrahi

• Jul 12th, 2009

Increate the size of database buffer cache.OrSet parameter pre_page_sge=trueThe main adventage is, all pages are touth to physical memory.The main disadvantages is, it create more active pages & more time to make connect.

Answer Question  Select Best Answer

kumaresan.m

 Profile Answers by kumaresan.m Questions by kumaresan.m

• Sep 12th, 2006

1)Database can be opened without tempfiles in the temporary tablespace.2) Tempfiles can't be renamed.3)Tempfiles doesn't need recovery.4)Segments in temporary tablespace are dropped when no longer required.

love_oracle

 Profile Answers by love_oracle Questions by love_oracle

• Feb 13th, 2006

Diffierence between tempfile and datafile are:1)tempfile does not want recovery2)tempfile can't be taken offline3)data of the tempfile lost when the oracle server shutdown

Answer Question  Select Best Answer