cmanne

 Profile Answers by cmanne Questions by cmanne

• Jul 29th, 2006

PUBLIC DATABASE LINKPRIVATE DATABASE LINK

Rani Rathna

• Jul 9th, 2005

You can create a private database link in a specific schema of a database. Only the owner of a private database link or  PL/SQL subprograms in the schema can use a private database link to access...

Answer Question  Select Best Answer

cmanne

 Profile Answers by cmanne Questions by cmanne

• Jul 29th, 2006

DBMS_METADATADBMS_STATSDBMS_SUPPORTDBMS_SESSION

akebono

• Aug 26th, 2005

 DBMS_OUTPUT.PUT_LINE('strings'); print out the strings  DBMS_UTILITY.get_time() get the current time  DBMS_ALERT e.g begin dbms_alert.register('myregister'); end  to register interst in a named alert   

Answer Question  Select Best Answer

select segment_name,sum(bytes) from dba_segmentswhere segment_name='TABLE_NAME' AND OWNER='OWNER of the table'group by segment_name

satish penugonda

• Jul 7th, 2006

And adding to the previous...view are not physical entities like tables which occupy space in the database..they are logical and whenever you select, the query underlying the view gets fired and results are returned. Hence, you cannot get the space information for views

Answer Question  Select Best Answer

ritesh raj singh

• Jul 4th, 2006

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM?...

Answer Question  Select Best Answer

These are a few of the advantages of using DBCA:You can use its wizards to guide you through a selection of options providing an easy means of creating and tailoring your database. It allows you to provide varying levels of detail. You can provide a minimum of input and allow Oracle to make decisions for you, eliminating the need to spend time deciding how best to set parameters or structure the database....

oradba

• Apr 6th, 2006

The Database Configuration Assistant guides you through the process of creating a new database, changing the configuration of an existing database, or deleting a database. Many of the database creatio...

Answer Question  Select Best Answer

Radha B S

• Mar 15th, 2006

Srinivas reddy Wrote: 1. Dynamic Memomry Management  2. Default tablespace at the db levele  3. temporary tablespace at the dba level 4. Undo tablespace managemnet (auto/manual)

srinivas reddy

• Mar 25th, 2005

1. Dynamic Memomry Management  2. Default tablespace at the db levele  3. temporary tablespace at the dba level 4. Undo tablespace managemnet (auto/manual)

Answer Question  Select Best Answer

innovative

 Profile Answers by innovative Questions by innovative

• Feb 20th, 2006

tablespaces are the logical constructs which are group of datafiles. a datafile belongs to one database. in laymans language we can say that tablespaces are like folders in windows environment. as we ...

Gurmeet Singh

• Feb 13th, 2006

Use of tableapce in oracle are:1) we can assign different quotas to the user of databasae2)we can take a part of database unavailable from the user3)we can create a object which have block size different from standard block size4) we can take backup of part of the database

Answer Question  Select Best Answer

krisna

• Feb 3rd, 2006

NO we can't create index on long raw column.

Answer Question  Select Best Answer

sheela

• Sep 7th, 2005

Function-based indexes can use any Function or Object method that is declared as repeatable. Queries using expressions can use the index. Ex:- CREATE INDEX sales_margin_inx  ON ...

Answer Question  Select Best Answer

Shrikant Pande

• Aug 24th, 2005

Yes : Schema objects can stored in different tablespace and a tablespace can contained one or more schema objects data.

sandeep

• Jul 4th, 2005

Yes , it can .  for example if you specify a different tablepace (B) for indexes, the indexes of the tables that the user create would be residing in B , and the table would reside in the user's default tablespace A. Rgds Sandeep Kurian

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

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

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

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

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

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

hash cluster --> preallocated based on number of keys and key size.  index cluster --> not preallocated  in both cases, you want to get the key size (amount of data associated with...

soccer_champ

• Jun 20th, 2005

Hash clusters are useful in cases where : (i) There is a uniform, even and predictable no. of key values. (ii) Queries using equality predicates. (iii) The table is NOT growing constantly, and the keys are rarely updated.

Answer Question  Select Best Answer

Mane

• Jul 8th, 2005

It can be, the only required option is that your tablespace have quota assigned to any user that want to store objects in it.

S.Velusamy Raja

• Jul 6th, 2005

Wish to know It can be or can not be. 

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

ramesh khanna

• Jun 27th, 2005

Collecion of objects

Answer Question  Select Best Answer