Tool for migrating from forms 3 to forms 6

Hi Gurus any one have idea of any tool which can be used for migrating from forms 3 to forms 6. Help needed in this is very much appreciated Ayap This communication contains information, which is confidential and may

Index creating

Hi Can we able to create index for a particular partition or for the data load on a particular day? Ayap This communication contains information, which is confidential and may also be privileged. It is for the

Virtual Address IN Oracle Fail Safe.. Urgent

Hi Can Any one help me in How to know what ip address to be given in configuring the Virtual Address in Fail safe. What should be the Host name and IP address we have to provide in this. RGDS Ayappan.S This

Can Partition be set an Session Level

Hi All Can we able to set the Partition in the Session Level. I.e if I have a partition table and when I am querying can I set it in the session Level Rgds Ayyappan.S This communication contains information, which is

RE: Can Partition be set an Session Level

Hi Dennis Williams U r correct while Querying the table I want to set at session level to use the partition. is it possible Rgds Ayyappan.S Ayyappan - I'm just trying to understand your question. Pardon me if I'm a little slow, it is Monday. Okay, you have a partitioned table. That is a

How to Install oracle 9i on windows cluster.

Hi all I have to install oracle9i on windows 2000 cluster environment. whether i have to install it in cluster or not. and what are all the steps to follow. Rgds Ayyappan.S This communication contains information,

RE: 8.0.5 to 8.1.7 - export/import

Hi It is Possible to import from NT to Solaris. The table space name should be the same otherwise build the table and then import by ignoring the errors. Ayyappan.S This communication contains information, which is

RE: collecting statistics

U can user sqlrowcount. This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s),

How to use Email server in 9iAS.

Hi I wish to install Email server in 9iAS. but i don't know how to do that. i try to download the same from OTN but unable to get it. so let me know how to do and configure the same Rgds Ayyappan.S This communication

RE: DBMS_STATS

ya u have to run the DBMSstat.sql which is in oracle_home/rdbms/admin/dbmsstat.sql after that u have to gather the statistics. Rgds Ayyapps This communication contains information, which is confidential and may

RE: Move index to another tablespace

Hi U have to rebuild the index only. u can't able to move from one tablespace to another like move table. Regards Ayyappan.S This communication contains information, which is confidential and may also be privileged.

RE: Move index to another tablespace

Hi Bee It is Correct and u can use the command to rebuild to another tablespace; Rgds Ayap Hi Ayyappan, Correct me if I am wrong. I think in 8.1.6, you can use the alter index command to move an index to a different tablespace eg. ALTER INDEX summit.orders_idx REBUILD TABLESPACE

RE: ORA-01000: maximum open cursors exceeded

Hi I think u can increase the open cursors at the maximum. currently I am having open cursors as 2000. so I think u can increase up to that Regards Ayyappan.S This communication contains information, which is

Table Insert Lock!!

Hi I have to revoke insert from a table where I am the owner of the Schema. is it possible. if so? how?. E.g. Owner a have a table t1 after inserting 1 row owner wish to revoke insert for the table t1. because t1 should not have more than one row. How to incorporate this. it is 8.1.7 on

RE: Accessing databases with different character sets

Hi use should use American.America.UTF8. in the client configuration Ayyapps This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended

How to register an package in oracle Database!!

Hi all I want to know how to register an Package in the oracle database and find whether that process is running or not. let me know how to do that? Regards Ayyappan.S.S This communication contains information,

Locally managed ts

Hi all Can we able to change the dictionary managed tablespace to locally managed tablespace. if so how? Ayyapps This communication contains information, which is confidential and may also be privileged. It is for

RE: problem in creating control file?

Hi U can use the Command Alter database backup control file to Trace. with the Trace file u can alter the some parameters and create the new control file Regards Ayyappan.S Oracle DBA Chennai This

Locally managed ts

Hi all Can we able to change the dictionary managed tablespace to locally managed tablespace. if so how? Ayyapps This communication contains information, which is confidential and may also be privileged. It is for

How to use dbms_stats.

Hi I want to know how to how to use dbms_stats. package and get the statistics This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended