Oracle - Oracle database server topics

Thread preview

Thread	Last Post	Replies

replace Oracle 8 with Oracle 9i	30 Nov 2005 06:11 GMT	1
Customer is upgrading an NT to Win3000, and I want to upgrade their Oracle 8 to Oracle 9i. I would prefer to just delete the entire Oracle 8 environment and do a clean install of 9i. Do I need to run an uninstaller to remove Oracle 8, or can I just delete the entire oracle
9i to 10g upgrade error	30 Nov 2005 02:39 GMT	2
Using Database Upgrade Assistant ORA-20000: Version 9.2.0.1.0 not supported for upgrade to release 10.2.0 ORA-06512: at line 1523
Global Variable passed as IN parameters, bug or feature?	30 Nov 2005 01:08 GMT	2
I have a strange thing happening related to global variables, and I want to know whether this is a bug or a feature. I am using Oracle 10g. I have this package.
oracle 8.0.5 client!	30 Nov 2005 00:45 GMT	3
I have to install and configure an oracle client on a PC running W2000. I should use version 8.0.5, apparently becauae the db was developed using this version. Well OK i should take advise.
oracle 9i replication	30 Nov 2005 00:40 GMT	3
We are using Oracle 9i on Windows2003 server and currently replicating 200 tables every 5 minuts to our reporting d/base. Is it possible to replicate a subset of data from the same tables? Thanks,
DBA Needed	30 Nov 2005 00:01 GMT	3
I need a DBA consultant ASAP. In the Mid Ohio area. Please Help!!
replace Oracle 8 with Oracle 9i	29 Nov 2005 23:49 GMT	5
Customer is upgrading an NT to Win3000, and I want to upgrade their Oracle 8 to Oracle 9i. I would prefer to just delete the entire Oracle 8 environment and do a clean install of 9i. Do I need to run an uninstaller to remove Oracle 8, or can I just delete the entire oracle
Use Intermedia(10g),do I need to install the companion 10g CD(got errors)??	29 Nov 2005 23:06 GMT	6
My current work is using Intermedia. (ver 8.1.7.4, they installed it before I came here to work). And we are trying to migrate to oracle 10g. And currently, I am building a test environment.
Segregation of Duties - IT Team	29 Nov 2005 23:04 GMT	6
Could you please help me to solve following problem? I am a newbe in word of databases / Oracle. What are the best practices in the SOD creation for IT Team for DB server? What (default) levels of IT Access are on avrage DB server? (superuser, backup operator, developer,
Wrong results or some configuration detail (Oracle 10G) ?	29 Nov 2005 22:38 GMT	2
Hi All ! Members please look this situation: To homolog Oracle 10g (to migrate) I check the results from one aplication (composed by 16 procedures). To test the results I install two databases in Oracle 10G, first in
ORA-01654	29 Nov 2005 22:20 GMT	6
I am not very knowledgeable with Oracle and I am getting this error mesage when trying to save data into our MRP database. The transactions are issued using a front end to Oracle called Obvious MRP. I am running Oracle 8i on a Netware 5.1 Server. I have verified that I have ...
modify table column	29 Nov 2005 21:17 GMT	2
We have a partitioned table with more than 30M rows. We want to increase the size of varchar2 data type, this column is part of primary key. Do you see any impact when doing this. Will Oracle lock the whole table for a long time since it has more than 30M rows?
Disallowing HTTP connections	29 Nov 2005 21:14 GMT	5
I have configured 10g AS rel 2 ph 2 to accept https (SSL) connections. Now I would like to make it so the SSL port (4445) is the only port that can be accessed. Is there a way to disallow regular http traffic? I tried taking down the corresponding origin server, but that didn't
DB2 HADB	29 Nov 2005 20:48 GMT	99
Has anyone worked with DB2 HADB? from what I gather it sounds exactly like dataguard? can anyone run through the differences if any thanks. Signature Rodrick R. Brown
DROP tables in PL/SQL	29 Nov 2005 19:44 GMT	5
what's the most efficient way to remove tables in procedure, i.e. example 1 CREATE OR REPLACE PROCEDURE usun_xxx as