| Thread | Last Post | Replies |
|
| More SQL counting questions... | 08 Aug 2005 15:19 GMT | 3 |
I have a table that looks like this: server_name severity log_only notification_only -------- -------- -------- ---------- serverA critical 0 0
|
| Server Name Change using Oracle 10G, db console does not work. | 08 Aug 2005 13:03 GMT | 4 |
If I am performing a server name change while on Oracle 10G. I discovered the db console did not work, even though I shutdown all of the services and databases. What is the method to change a server name in Windows 2003, in
|
| sqlQuery as string | 08 Aug 2005 07:16 GMT | 9 |
Which are the functions usable in SQL that would take an SQL query as string parameter (VARCHAR)?
|
| Help: Multiple Oracle_HOME, Oracle_version on same machine | 08 Aug 2005 01:00 GMT | 3 |
I am required to install multiple Oracle version on smae machine. Oracle 9202, 9203, 9206 on same RedHat Linux AS 3, for different vendors. So I created three users and three groups, ora9202:ora9202_dba, ora9203:ora9203_dba, ora9204:ora9204_dba, with differenct Oracle_Home,
|
| select * from pictures where number_of_black_holes > 10 | 08 Aug 2005 00:09 GMT | 1 |
Do anyone knew something about progress in research about developing sql that can analyze pictures or videos? Greeting Bjørn
|
| standby_file_management question | 07 Aug 2005 05:59 GMT | 2 |
I found a note, Note:221130.1, which got me by (had a createion error) BUT the question remains: Why wasn't the standby_file_management able to create a directory? I figured this out from reading the note AND doing it:
|
| RMAN / nocatalog | 07 Aug 2005 05:50 GMT | 4 |
I was reading the RMAN manual and needed a bit of clarification on a few things: 1) When you issue the command "using backup controlfile", that basically means you will be performing a PIT recovery, and the SCN's in
|
| explain plan changes if using bind vars | 06 Aug 2005 18:33 GMT | 12 |
I have a query that changes explain plan for the worse if I change non-bind vars to bind vars. Discovered this yesterday, when was trying to figure out extra dblink chatter (see reduce dblink (database link) chatter thread):
|
| Does Oracle Have a Way to Store Historical Changes to Records? | 06 Aug 2005 18:01 GMT | 19 |
I am sure it does, but I am not sure of its marketing name. Say you have a record that was created and now a user has edited the record. Does Oracle have a way of storing both the original record and modifications? Sort of like an audit trail or history of changes.
|
| Declaring a global table in PL/SQL | 06 Aug 2005 07:23 GMT | 5 |
Why can't I have? CREATE OR REPLACE PACKAGE BODY test AS TYPE test_table IS TABLE OF VARCHAR2(30) INDEX BY VARCHAR2(2);
|
| Oracle 8i logfile problem | 06 Aug 2005 05:11 GMT | 8 |
We have oracle 8i running on a sun machine. Our DBA just left and of course the database died. Somehow I was elected to try and fix it, but Im a software engineer, I know very very very little about oracle. When I run the startup script, I get the following:
|
| 10g:ORA-12547: TNS:lost contact-only over BEQ not TCP | 06 Aug 2005 01:57 GMT | 3 |
I have oracle 10g 10.1.0.2 installed on HP Tru64 5.1.b. As the Oracle software owner I can create an instance and connect to it locally by using nothing but the ORACLE_SID. As a normal local unix user on the same server I can not connect
|
| Creating indexes on a large table | 06 Aug 2005 00:34 GMT | 12 |
Creating indexes on a large table Hi, I have 2 large tables on which we have to create indexes. Table 1: ( Contains 4 Billion Records )
|
| RMAN 8i and NLS_DATE_FORMAT | 05 Aug 2005 23:16 GMT | 2 |
Hey, all. Shockingly, RMAN (8.1.7.4 on AIX 5.2) is still refusing to give up all its secrets. I am working on TSPITR.
|
| Setup 10G to access external DLL on windows2000 - ORA-06520: PL/SQL: Error loading external library | 05 Aug 2005 22:45 GMT | 1 |
Neither I nor the C coder that i am working with has attempted to setup an external procedure before so the help is greatly appreciated. Does the following error mean that oracle configuration is correct and now there is an issue with the DLL itself?
|