Public database link is created for the special user group PUBLIC. A public database link can be used when any user in the associated database specifies a global object name in a SQL statement or object definition.

edeed

 Profile Answers by edeed Questions by edeed

• Mar 27th, 2008

A database link is a pointer that defines a one-way communication path from an Oracle Database server to another database server. The link pointer is actually defined as an entry in a data dictionary ...

Answer Question  Select Best Answer

A materialized view is a replica of a target master from a singlepoint in time. The concept was first introduced with Oracle7 termed asSNAPSHOT. In Oracle release 7.1.6 snapshots were enhanced to enableDMLs along with a new terminology, updatable snapshots. With Oracle8.1.6 snapshots started to be used in data warehouse environments so anew terminology materialized view was introduced to address bothdistributed...

irfanyell

 Profile Answers by irfanyell Questions by irfanyell

• Apr 24th, 2008

Both are mirror copy of tables but in that main difference is in snapshot we cannot edit the data. in the case of materialized view we can edit the data.

pravin Karde

• Sep 25th, 2006

sir  i m a M.E. student & i developed a project on Materialized view selection & maintenance.sir for this i urgently need the architecture of Materialized view & its operation. sir pl. help me & send me if  possible.thanks waiting +vely.

Answer Question  Select Best Answer

sanjayoracle

 Profile Answers by sanjayoracle Questions by sanjayoracle

• Apr 25th, 2008

Just in simple words.....Ora01555 error occurs when a transation fails when it cannot able to find read consistence image in rollback segment. To solve this problem: Increse the Undo_RetentionCheers :)

Mohammed Abdul Afroze

• Mar 25th, 2007

Answer: Avoiding Snap Shot too old error-(oerr ora 01555).   First thing here we understood how is the rbs works.This will work in circular fashion by looping around the reuse of the ex...

Answer Question  Select Best Answer

raghu2110

 Profile Answers by raghu2110 Questions by raghu2110

• May 20th, 2008

Blob datatype is used for storing large Binary data Like Photos,signatures etc Clob datatype is used for stoeing large character data upto 4GB like resume and other docs

manish hoiyani

• Sep 14th, 2006

Clob, blob, used to unstructured data and binary data respectively.

Answer Question  Select Best Answer

The set of Redo Log files for a database is collectively known as the database's redo log.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 21st, 2008

Oracle maintains logs of all transactions against the databse. These transactions are recorded in files called Online Redo log files.These logs are used to recover the database's transaction in th...

sampath kumar

• May 17th, 2006

Red log file store the changes in the data file.it mainly used for recovery purpose..

Answer Question  Select Best Answer

The Primary function of the redo log is to record all changes made to data.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 21st, 2008

Oracle maintains logs of all transactions against the databse. These transactions are recorded in files called Online Redo log files.These logs are used to recover the database's transaction in their ...

sujeshm

 Profile Answers by sujeshm Questions by sujeshm

• Feb 27th, 2006

Redo log is a part of physical structure of oracle. its basic function is to record all the changesmade to daatabase information. wheneveer an abnormal shutdown take place preventing system to update the database, changes can be obtained from redolog and hence the changes are not lost.

Answer Question  Select Best Answer

Here i'm sending all of you the error which occurred frequently during database connection.While creating a data block in Oracle Forms, the error which encountered frequently is "ORA-12560: TNS Protocol Adapter Error" During lectures instructor had told us that if such error encountered then copy the TNSNAMES.ORA file from ..oracleora92networkadminsample to forms9inetworkadminsample as it contains...

sahil4439

 Profile Answers by sahil4439 Questions by sahil4439

• Jun 15th, 2008

dude  ur databse is not running...right click on my compiuter>manage>services& applictaions(on right side)>services>oracle_databse_name(the datasbe  that ur  trying ...

Answer Question  Select Best Answer

what is remote login user and local user in database?And sid is used when user want to login as local user and Glodal database name is used when user wants to login as remote user..What does it mean ?

cmanan

 Profile Answers by cmanan Questions by cmanan

• Jul 10th, 2008

When you have distributed environment,you may access one database from other.This is normally done  via db link.So lets say you have flight database and customer dabatabase.Now from customer data...

Answer Question  Select Best Answer

Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace.

swetashashi

 Profile Answers by swetashashi Questions by swetashashi

• Apr 16th, 2009

Databases, tablespaces, and datafiles are closely related, but they have important differences:1) An Oracle database consists of at least two logical storage units called tablespaces, which collective...

swetashashi

 Profile Answers by swetashashi Questions by swetashashi

• Apr 16th, 2009

Each databases logically consists of one or moretablespaces One or more data files are explicitly createdfor each tablespace.

Answer Question  Select Best Answer

mmaz2002

 Profile Answers by mmaz2002 Questions by mmaz2002

• Jul 15th, 2009

All Extent info is maintained in Dictionary which is infact a dis-advantage, Also in case of a huge insert operation undo is generated.

deep chandan

 Profile Answers by deep chandan Questions by deep chandan

• Dec 30th, 2008

The main advantage of using dictionary managed tablespaces is that in this we can give the size of the extents according to our need. We can modify extent size but in locally managed tablespace extents are of uniform size.

Answer Question  Select Best Answer

No Limit.

jjvetri

 Profile Answers by jjvetri Questions by jjvetri

• Aug 5th, 2009

You can create any number of check constraintsseparated by AND, OR, or NOT to create more complex conditions.

Answer Question  Select Best Answer

From where does PMON gets the informance about failure? How is the user process terminited?

premk

 Profile Answers by premk Questions by premk

• Dec 23rd, 2009

When user process is terminated abruptly due to power cut or any other factors then oracle database instance goes down then PMON mandatory background process is activated i.e it will then writes the c...

aabishkar

 Profile Answers by aabishkar Questions by aabishkar

• Sep 28th, 2009

When a user process fails or when it is killed, it then cleans up the cache and frees resources that the process used. PMON checks server processes and restarts them if they have failed.

Answer Question  Select Best Answer

A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.

pravesh28

 Profile Answers by pravesh28 Questions by pravesh28

• Mar 27th, 2010

Table is manager which contain row and colomnin which store data ande retrive data

thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 24th, 2006

Table is data base object which stores the data in the logical representatiom in form of rows n coluns which is existing in two dimension form... and is stored in the databse.

Answer Question  Select Best Answer

A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)

pravesh28

 Profile Answers by pravesh28 Questions by pravesh28

• Mar 27th, 2010

View means virtualit is virtual table drived from base tableview doesnt contain any data view is mirrar image of data that we  can set the its size

C.Ramesh

• Oct 17th, 2007

View is a Virtual Table. It likes like a table. View provide additional level tabel security and providing selected columns only and it accessing different tables no need to joins of different tables. Views also stores data like (Materialized Views) it can be referesh methods like fast, complete.

Answer Question  Select Best Answer

Synonyms are used to : Mask the real name and owner of an object.Provide public access to an objectProvide location transparency for tables, views or program units of a remote database.Simplify the SQL statements for database users.

harrykhokhar

 Profile Answers by harrykhokhar Questions by harrykhokhar

• Jun 1st, 2010

Synonyms are alternative names for the objects like views, indexes, etc.

Answer Question  Select Best Answer

Yes.

matabrez

 Profile Answers by matabrez Questions by matabrez

• Jan 10th, 2011

Yes one tablespace can hold objects from different schemas.Eg. when we create any schema (user) than we can assign default tablespace like this for any user user we can use same tablespace. Eg. SYSTE...

Answer Question  Select Best Answer

ORACLE database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.

matabrez

 Profile Answers by matabrez Questions by matabrez

• Jan 10th, 2011

Smallest logical of Oracle database. In Oracle 10g default data block size is 8192 byres means 8k.
Other data block size are 2k, 4k, 8k, 16k, 32kWe have only these available data blocks in oracle database.

C.Ramesh

• Oct 27th, 2007

Oracle Data Blocks is logical storage unit of Oracle and One Oracle Data Blocks containts multiple of Operating system Blocks. Data blocks contains contigous of Bytes.

Answer Question  Select Best Answer

Hi,

If a user executes a query which is already being used by a view exactly will oracle use already existing view to retrieve data or use the query executed by user?

Regards,
Shashi

Aayudh

• Aug 24th, 2011

Oracle uses query executed by user because when you use a view name in an other query, it simply transform query. select empid,name from emp; --- original create view emp_view as select empid,name f...

Answer Question  Select Best Answer

Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition of the owner's views or procedures.

Ravikumar

• Oct 18th, 2011

Database link is created by a user in his schema,it has 2 types

1.private database link
2.public database link /global

private database link is access the object in separate user

syntax:

create database link connect to username identified by password using 'db_name';

kailasTile

 Profile Answers by kailasTile Questions by kailasTile

• Oct 14th, 2011

Private database link is created by a user in his schema. While creating the link, the keyword GLOBAL is not used. The syntax for creation is CREATE DATABASE LINK myPrivateDBLink connect to identified by using ;
Private DB links can not be used by other schema's.

Answer Question  Select Best Answer