senthilora

 Profile Answers by senthilora Questions by senthilora

• Sep 24th, 2007

Another suggestion could be: Find the Master Table(s) of the given table and export / import them all.

balakrishna

• May 28th, 2006

If u want to import the table just say constraints=n the movement table got imported then u create constriant on that tables.

Answer Question  Select Best Answer

senthilora

 Profile Answers by senthilora Questions by senthilora

• Sep 24th, 2007

ORA-1555 error can occur in Oracle 10g also even with UNDO RETENTION GUARANTEE enabled. ORA-1555 happens, when Oracle server process could not find the block-image in UNDO tablespace for the read...

paparao

• Oct 23rd, 2006

This shanshot too old. -> problem occurs generally in 9i only.  Whether in 10g, at the time of tablespace creation, retuntion guarentee is applied it automatically we can supress( by default i...

Answer Question  Select Best Answer

Sriniv@s..

• Jun 8th, 2012

SQLNET.ORA :: It is the optional network configuration file.it contain network configuration details.
LISTINER.ORA : It is the listener file for creating at server side
TNSNAMES.ORA:client side configuration file.it was matched with listener file.it for remote access.

Patrick McShea

• Nov 15th, 2006

SQLNET.ora tells you what path to take in resolving the name of an instance (among other things). In the context of this question, the NAMES.DIRECTORY_PATH parameter specifys the order of the naming methods used for client name resolution lookups. (TNSNAMES, ONAMES...)

Answer Question  Select Best Answer

How to check whether database whether it is opened by pfile/spfile.

Kapil Relan

 Profile Answers by Kapil Relan Questions by Kapil Relan

• Apr 15th, 2011

if you are not aware about what your database has chosen at startup ie PFILE or SPFILE you can simply try the following SQL statement:,which i tried create spfile from pfile;if you get the output that...

clevelcd

 Profile Answers by clevelcd Questions by clevelcd

• Jun 5th, 2008

Another alternative: SHOW PARAMETER SPFILE;

Answer Question  Select Best Answer

There are about a 10,000 records in a table. A user 1 runs a query which is doing a full table scan. While doing the full table scan, user 2 changes some value x to y using a DML statement in record. What does the the 1st user see ( x or y ) ? If x, then where is the value stored?

sviru

 Profile Answers by sviru Questions by sviru

• Jul 12th, 2011

X and that is read from undo segment

sean21

 Profile Answers by sean21 Questions by sean21

• Mar 8th, 2010

There are about a 10,000 records in a table. A user 1 runs a query which is doing a full table scan. While doing the full table scan, user 2 changes some value x to y using a DML statement in record. ...

Answer Question  Select Best Answer

If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan?

SSR

• Jul 20th, 2011

Depends on cardinality, for low cardinality then full scan better

prashanthpadal

 Profile Answers by prashanthpadal Questions by prashanthpadal

• Mar 23rd, 2011

If the query has to get the output more than 5% of the full table then full scan is better than Index scan. Here is the matter of 35% then, it should go though full table scan.

Answer Question  Select Best Answer

If dead lock happened for 2 applications at a time in a banking sector..how to resolve this issues without forcing any one of the application ..we should not have to stop the transaction...

Dharma Kotha

 Profile Answers by Dharma Kotha Questions by Dharma Kotha

• Oct 10th, 2011

A deadlock occurs when data was locked simultaneously by two sessions(users) and waiting for data, this can be resolved by rollback statement.

dharma

• Aug 23rd, 2011

Dead Locks can be resolved by rollback statement.

Answer Question  Select Best Answer

Sriniv@s..

• Jun 5th, 2012

Schema is a set of objects own by particular user.
Tables,indexes,Triggers,constraints etc..are schema objects..

Jacob

• Jul 9th, 2005

A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are logical structures created by users. Objects may define areas ...

Answer Question  Select Best Answer

sivaraju.sateesh

 Profile Answers by sivaraju.sateesh Questions by sivaraju.sateesh

• Apr 7th, 2009

Private synonym is a synonym which resides in the owners schema

Dan

• Jul 9th, 2005

To create a private synonym in your own schema, you must have CREATE SYNONYM system privilege.  To create a private synonym in another user's schema, you must have CREATE ANY SYNONYM system ...

Answer Question  Select Best Answer

imran44

 Profile Answers by imran44 Questions by imran44

• Jul 10th, 2009

At the time of database creation 2 redo log files are created, these redo log files act in circular fashion, when log switch occur, redo log file will dump its contents in archived log destination, an...

nagabhushan reddy

• Feb 8th, 2006

Redo log file contains data which changes made to the database.it is used for recovery purpose.

Answer Question  Select Best Answer

imran44

 Profile Answers by imran44 Questions by imran44

• Jul 10th, 2009

SGA+Background Process = InstanceAs soon as user process starts and server process takes control from user process, instance created with help of background processes and most important background pro...

cmanne

 Profile Answers by cmanne Questions by cmanne

• Jan 4th, 2006

An Oracle instance is a combination of background processes and memory structures (SGA)

Answer Question  Select Best Answer

 A  database  instance  (Server) is a set of memory structure and background processes that access a set of database files. The process can be shared by all users. The  memory  structure  that  are  used  to  store  most  queried data from database.  This  helps up to improve database performance by decreasing the...

ranjanam

• Aug 26th, 2007

Database instance(server) is the combination of memory structure and background process. It's a way to connect to the oracle database.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Aug 18th, 2007

A database instance also know as server is a set of memory structures and background processes that access a set of database files.It is possible for a single database to be accessed by multiple insta...

Answer Question  Select Best Answer

venu

• Sep 1st, 2012

The transportabel tablespaces enable us to transport data objects across different platforms.

Backing up or recovering a particular user/schema objects or data objects or tablespaces or entire databases is possible, which cannot be done using other backup techniques.

Sriniv@s..

• Jun 2nd, 2012

Moving data using transportable tablespace can be much faster than performing either export/import or unload/load of the same data.Bcz transporting a tablespace only requires the copying of datafiles & integrating the tablespace structural information.

Answer Question  Select Best Answer

MA123

 Profile Answers by MA123 Questions by MA123

• Jan 25th, 2008

Snapshots can't upated. While MV can be updated contantley.

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jun 19th, 2007

No difference ..snapshot was used untill v8 and 8i onwards called mv

Answer Question  Select Best Answer

How would you plan for an Oracle upgrade? What are the prerequisites?

deepak subramoniam

• Aug 3rd, 2014

Ensure the nls Characterset of the parent and child database are same
Ensure the editions of both the database are same.
Ensure UTL_SMTP,UTL_HTTP,UTL_FILE Packages are available. (for 10g to 11g se)
wm_concat needs to be changed in the 11g because in 11g the function will not be supported by Oracle

rohith

• Jul 21st, 2014

if u want to any up-gradation in oracle first we need to check version compatibility like if u want to upgrade from 10g to 11g the 10g version should be 10.2.0.4 or 10.2.0.5. then install the 11g sof...

Answer Question  Select Best Answer

senthilora

• Sep 24th, 2007

And.. I think, the question is about Data Migration - something related to migrating data between different databases.I have done using different tools like Data Junction, Informatica, even PL/SQL and SQL Loader.

Jacob Asirwadam SK, Biguvu

• May 21st, 2007

RAC stands for Real Application Cluster. In previous versions, it is known as PARALLEL SERVER. RAC is a mechanism that allows multiple instances (on different hosts/nodes) to access the same database....

Answer Question  Select Best Answer

Sriniv@s..

• Jun 2nd, 2012

SGA(system global area) & PGA(program global area) are two memory structures in oracle. SGA::is used to store shared information.It having Buffercache,Redolog buffer,Shared pool,java pool,Larg pool an...

AJU JOHNSON

• Apr 29th, 2005

PGA Program global area Contains  Session variables ,Stack space,Cursor status ,Sort Areas

Answer Question  Select Best Answer

Pooja Agrawal

• Nov 22nd, 2006

Additionally,PGA_Aggregate_target set when Work_area_policy is set to auto and FAST_START_MTTR_Target set may also affect d/b performance

Ratna Kumari

• Aug 2nd, 2005

These are the Parameters for init.ora  DB_BLOCK_BUFFERSSHARED_POOL_SIZESORT_AREA_SIZEDBWR_IO_SLAVESROLLBACK_SEGMENTSSORT_AREA_RETAINED_SIZEDB_BLOCK_LRU_EXTENDED_STATISTICSSHARED_POOL_RESERVE_SIZE

Answer Question  Select Best Answer

senthilora

 Profile Answers by senthilora Questions by senthilora

• Sep 24th, 2007

PARTITION is one of the options, which you can enable when you install Oracle Enterprice Edition.You may enable it later if you didn't choose to install at first time.  You will have to insta...

V.A.SURESH

• Nov 12th, 2005

Install 8i enterprise version. partition enables automatically

Answer Question  Select Best Answer

RASH

• Mar 24th, 2007

I'm sceptical about the .mdb.The simple, answer is Fixed width or Delimited TEXT files.

vnktummala

 Profile Answers by vnktummala Questions by vnktummala

• Jun 30th, 2006

1. .txt2. .dat3. .csv4. .mdb

Answer Question  Select Best Answer