Search results for query: *

hi, I am trying to shutdown the database with normal shutdown option but i am unable to shutdown the database with any of the option except abort.Can anybody suggest me what could be the reasion for this as i am unable to perform cold backup i m running oracle 8i on top of sco unixware.I have...

hi once again, I just wanted to know when desinging and allocating space for the SGA what all factors determines the size of shared pool ,Database buffers large pool and java pool size.Please reply as matter is very urgent.I want to design a database for OLTP operation but please provide me a...

Hi Friends, do anybody know the answer of this problem?? PMON has gone defunc on unix server running in 24X 7 computing environment as far as i know if any of the background process dies we got to restart oracle but as this process has gone defunc can we recover it without shutting down the...

hi, I am installing oracle 8.1.5 on unixware server but when it tries to link net8 product it stucks and does not proceed further.I have tried many times i m not using OFA installation so i have only two mount points.I have created a group DBA and one user oracle and performing installation...

oracle does not allow creation of indexes on views because when a query is executed on the view it usess indexes of underlying tables. Instead you can analyze the query to find out if your query on view is using indexes of the underlying tables.

thanx guys i am about to user your ideas.

Hi , I am using oracle 8.1.7 .Now my problem is i am receiving data in the form of flat files at regular intervals (say an hour) I have to keep on updating my database with the arrived data to keep it upto date.I am running Oracle on top of SCO Unixware. So is there any way by which i can...

hi once again, I have got a very specific proble. I am running oracle 8.1.7 running on SCO UNIXWARE 7.1 Non Stop Clustering environment.Now the problem is after a specific period say 7 days it stops responding and it gives an error "ORA-12560: TNS:protocol adapter error " I have tried...

Hi, I had an oracle 7.1.6 running on SCO Unix Open server release 5.0 .I have experienced a crash.Now i have reinstalled oracle but now the problem is though i have installed forms 3.0 but i am unable to link it .Problem seems to be with forms executable SQLFORMS.MK because after installation...

I AM RUNNING ORACLE8I VERSION 8.1.7 AND 8.1.5 I HAVE EXPORTED A FILE USING EXPORT UTILITY IN ORACLE 8.1.7 AND TRYING TO IMPORT IN DATABASE RUNNING ON ORACLE VERSION 8.1.5 I AM UNABLE TO IMPORT THE EXPORTED FILE CREATED IN 8.1.7 DATABASE TO ORACLE 8.1.5 DATABASE ERROR WHICH I GET IS Export...

i have two PC's placed in two different locations i am using telephone line for connectivity using modems on both the ends .I am unable to establish connectivity using windows 2000 dialup connectivity is there any solution to it. Is there any way of connecting to my server from a remote location...

please tell me how to implement firewall in oracle 8.1.7 server running on unix server thanx in adv.

i am using oracle 8i running on non stop clusetered server on sco unixware. is there a wqay using which i can implement firewall ? please explain me how and where exactly . thanx in adv.

when using execute_query on block with when_validate_item trigger at item level it does not work properly can anybody suggest how to use both in same block also unable 2 use prameter query i mean i want to pass a parameter to a field and then depending on that parameter valu i want to execute...

hi once again forms 3.0 is CUI and it creates inp file not fmb can i convert inp file too using forms 6i?

i have my oracle database 7.1.6 running on SCO unix 5.0.5. i am using forms 3.0 which is CUI. now i want to migrate my database to 8i and forms 3.0 to 6i can anybody suggest me how to go about it?

what is the relation between rollback segment and redo logs?

Can anybody tell me what is the relationship between rollback segments and redo logs in a transaction processing?