Oracle - Oracle database server topics

Thread preview

Thread	Last Post	Replies

Multihomed Install	12 Apr 2006 19:53 GMT	4
I am trying to do a new install (10g on Sun V480 running Solaris 10) on a multihomed machine. It has two IP addresses. According to the documentation, as I am aware of and understand it, if the ORACLE_HOSTNAME env var is not set, the first entry in the
Oracle Text Question	12 Apr 2006 19:26 GMT	4
Oracle 10g V2 on Linux. I have a contacts database with contact, address, phone number, email, contact activity (etc) tables. The users want a global search that will print a list of contacts where a specific keyword (say 'wellstone') occurs
PL/SQL code for inserting data based on a checkbox value	12 Apr 2006 18:42 GMT	1
I am trying to insert data from two tables into specified table depending on the state of a checkbox. I am using Oracle HTMLDB to do it. Below is the process for when the 'submit button' is pressed. I know it is definately wrong as it is
Skipping internal statements in Statspack??	12 Apr 2006 17:22 GMT	1
We are using Oracle 10.1.0.2 on windows 2000 SP 4. Statspack reports generated show lot of Oracle internally issued statements, I would like to know how to skip these statements and take only those which are executed by our application. TKprof has parameter SYS=NO to skip
Adding Another Datafile	12 Apr 2006 16:46 GMT	4
I am on oracle 8.1.7 version Windows 2000 Server. Using Enterprise manager i added another datafile (INDX02.DBF) of 500 MB into existing INDX tablespace which already contained one Datafile INDX01.DBF. Upon creation of new Datafile Oracle Enterprise Manager gives the extension
Select result with column from rows in another table.	12 Apr 2006 15:26 GMT	3
Hi to all I have this two table : TABLE A : \|column_a \| column_b\|
Oracle Enterprise Manager RMAN CREATE CATALOG	12 Apr 2006 14:29 GMT	1
ORACLE 9.2 Win XP Enterprise Manager I've a connection to Oracle Manager Server and two databases SAKE and MAKI. MAKI is CATALOG database and SAKE is the TARGET database. I would like to now, how to create the catalog (CREATE CATALOG) in ORACLE
SQL+ worksheet.... Clearing the output?	12 Apr 2006 12:55 GMT	9
Anyone know a way to clear the lower half of SQL+ Worksheet? Can't use CLEAR SCR in the worksheet. I want to be able to clear it from the SQL command pane. Thanks!
truncate partition table causes high latch free	12 Apr 2006 10:54 GMT	2
We have a partition table which has 60 partitions using composite range-hash partition. Each day we need to truncate one range partition to purge the history data.
Calling Job from a Job..	12 Apr 2006 10:36 GMT	2
Is it possible to call a job after finishing a Job.Example I have two jobs Job1 and Job2. How should I call Job2 after finishing Job1.Can I trap any returning value after successful execution of Job1.I know its possible through
Oracle market share	12 Apr 2006 06:09 GMT	3
Any ideas where I can find a recent overview of the market share of Oracle database products versus other vendors ? I'm especially interested in a comparison between Windows and UNIX platforms and the "popularity" of 10g on Linux versus other UNIX platforms (AIX, Solaris, ...).
hey	12 Apr 2006 02:31 GMT	4
why u deying my request , its a public group so i am eligible to submit my requierments too ... ..... :-p
reg-OCA	12 Apr 2006 00:38 GMT	2
hi friends, my name is pavan.am working as oralce DBA. i wann to write the OCP exam.so i need to complete OCA first. i wann to know what are the papers need to be written to get OCA.bcz
How to get a cursor from a dynamic query within a procedure?	11 Apr 2006 22:24 GMT	2
I want to execute a dynamic query using "EXECUTE IMMEDIATE" and return the result as a OUT parameter of procedure. I can not use OPEN test_cur FOR..." method so is there any other way to do this? And what about if I want to do this and return an int from that dynamic
ORA-01779, cannot get reason for	11 Apr 2006 21:32 GMT	3
i'm trying to understand the concept of key-preserved tables but failed so far. let me give you a trimmed down version of my objects: > create table m (id number primary key, col number); > insert into m values(1,1);