When exporting using filesize parameter, if three files is generated. How the Oracle name this three files?

jp1985verma

 Profile Answers by jp1985verma Questions by jp1985verma

• Oct 22nd, 2009

When Export reaches the value you have specified for the maximum FILESIZE, Export stops writing to the current file, opens another export file with the next name specified by the FILE parameter, and c...

Answer Question  Select Best Answer

What are the different scenarios for rebuilding indexes...

chandubtech

 Profile Answers by chandubtech Questions by chandubtech

• Aug 2nd, 2008

Actually you need to rebuild the indexes for 2 main scenarios.1)deleted entries represents 20% or more of the current entries2)the index depth is more than 4 levelsOracle index nodes are not deleted p...

Answer Question  Select Best Answer

how to change the log_archive_format parameter in pfile if corresponding issys_modifiable parameter is "FALSE"
give me the full step by step procedure.


Thanks
Gyan

Srinivasa Reddy

• Aug 18th, 2011

As per Oracle document if the parameter value in ISSYS_MODIFIABLE column ( in v$parameter view ) is ... *IMMEDIATE - Parameter can be changed with ALTER SYSTEM regardless of the type of parameter fil...

Answer Question  Select Best Answer

How to collects the "current" redolog members(redo group) if these are physically deleted. There is no backup and NARCHIVELOG mode in database

Mohammed irfan Hussain

• Feb 8th, 2016

The moment you start the instance the smon gets started and collects redolog member data to datafiles. i,e crash recovery.

Answer Question  Select Best Answer

krantideepak_v

• Apr 1st, 2005

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

Answer Question  Select Best Answer

soccer_champ

• Jun 18th, 2005

A Cluster is made up of a table, or group of tables that share the same data blocks, which are grouped togather because they share common columns and are often used together. In case of any doubt, mail me : bobby_1020@hotmal.com

Answer Question  Select Best Answer

soccer_champ

• Jun 20th, 2005

An index cluster uses an index to maintain data within the cluster. The structure of a cluster index is similar to a normal index. Although a normal index does not store NULL key values, and inde...

Answer Question  Select Best Answer

Rani Rathna

• Jul 9th, 2005

Oracle allows you to create private, public, and global database links.    Private Database Link: You can create a private database link in a specific schema of a database. Only the own...

Answer Question  Select Best Answer

Rani Rathna

• Jul 9th, 2005

When an Oracle network uses Oracle Names, the names servers in the system automatically create and manage global database links for every Oracle database in the network. All users and PL/SQL subprogra...

Answer Question  Select Best Answer

Karthikeyan.M

• Apr 6th, 2005

Block is the smallest unit of storage in the logical structure of the database where  actual table rows are stored.

Answer Question  Select Best Answer

soccer_champ

• Jun 20th, 2005

The primary block size is defined by the Initiaization parameter DB_BLOCK_SIZE.

Answer Question  Select Best Answer

sandhya

• Jun 27th, 2005

Segment is the collection of extents allocated to paricular object like table and index. Table segment and index segment

Answer Question  Select Best Answer

Maheen

• Jul 9th, 2005

A segment is a set of extents that contains all the data for a specific logical storage structure within a tablespace. For example, for each table, Oracle allocates one or more extents to form that ta...

Answer Question  Select Best Answer

Maheen

• Jul 9th, 2005

Oracle creates the index segment for an index or an index partition when you issue the CREATE INDEX statement. In this statement, you can specify storage parameters for the extents of the index segmen...

Answer Question  Select Best Answer

sri

• Aug 4th, 2005

Temporary Segments are created by ORACLE when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segments extents are released to the system for future use.

Answer Question  Select Best Answer

ramesh khanna

• Jun 27th, 2005

Collecion of objects

Answer Question  Select Best Answer

sri

• Aug 4th, 2005

It consists of - one or more data files  - one or more control files  - two or more redo log files  The database contains - Multiple users/schema's  - ...

Answer Question  Select Best Answer

Answer for this questions is NO. Standby database must be on same version of database and same version of Operating system.

Manoj

• May 2nd, 2005

Yes you can configure your stand by server with Advance Replication provided by Oracle 8i onwards on different OS. But the Oracle version should be same.  My Current senario Primary DB is on Unix and Secondary DBs are on Windows. 

Answer Question  Select Best Answer

Amit

• May 7th, 2005

Use dbms_shared_pool procedure. EXECUTE DBMS_SHARED_POOL.KEEP(OBJECTNAME); 

Answer Question  Select Best Answer

IRINA

• Apr 10th, 2005

The basic memory structures associated with Oracle include:  ? System Global Area (SGA), which is shared by all server and background  processes and holds the following:  o Database bu...

Answer Question  Select Best Answer