kailasTile

 Profile Answers by kailasTile Questions by kailasTile

• Mar 27th, 2008

Failover: Primary fails and standby is made primary.Switchover: Primary and secondary interchanges the role.Effectively, in both cases, standby becomes primary, main difference is, when failover happe...

Answer Question  Select Best Answer

How to assign an index tablespace for a database permanently, so that whatever indexes we are creating in the database, should automatically goes to that tablespace i.e. we neednot supply the tablespace name during index creation.

kailasTile

 Profile Answers by kailasTile Questions by kailasTile

• Dec 17th, 2007

There is no such provision in oracle to have default index tablespace. Workaround is- you can have a job which will scan for indexes in other tablespaces and rebuild into desired one.

Answer Question  Select Best Answer

Hi, I've recently commissioned a hosted system from a developer who has recommended using J2EE and Oracle. Their J2EE system is quite slick and works very well in preproduction. It uses annotations to generate the Oracle tables on the fly during deployment. On examination of the table structures that it's generated though, it's defaulted all of the VARCHAR2 definitions to 255 characters. On asking...

kailasTile

 Profile Answers by kailasTile Questions by kailasTile

• Dec 18th, 2007

Changing VARCHAR2(255) to precise required width is good table design. Though it will not improve performance as such.

Answer Question  Select Best Answer

kailasTile

 Profile Answers by kailasTile Questions by kailasTile

• Dec 17th, 2007

It depends on your requirement, if you want no of users around 300 then you can still achieve that by keeping PGA parameters low. If you are looking for number of users 1000 or even more, you need to go for shared server mode. 

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