| Thread | Last Post | Replies |
|
| Anyone using nagios? | 30 Jun 2009 09:11 GMT | 4 |
If so what do you think about it? Are you using it only on linux systems or across multiple unix systems or ... ??? How useable is the alerting and monitoring?
|
| physical standby database on other platfrom?? | 30 Jun 2009 00:46 GMT | 5 |
I need to know there is any possible way to create standby database on other system platform than production database. example : prodaction is on linux and standby will be on windows Reagrds - MJ
|
| initial value on create table/index statement | 29 Jun 2009 22:55 GMT | 11 |
Is there a way to change the value of "inital" in "create table" or "create index" during imp? Pre-creating table is not an option here. I am taking a export dump with rows=n from production and importing it into dev/QA and since the production tables/indexes have larger values
|
| Strange behaviour of Cramer query | 29 Jun 2009 19:43 GMT | 8 |
OS: Solaris 5.10 Oracle: 10.2.0.2 Application: Cramer see http://en.wikipedia.org/wiki/Cramer_Systems I was ask to look at a performance issue on a database used for
|
| RMAN Recovery | 28 Jun 2009 15:23 GMT | 3 |
We had a developer make some changes to production. Idiot. Anyhow, we have a complete backfrom from about 9:00am. There were some changes arounf 12:00 which are fine. The developer made changes at 3:30 and messed everything up.
|
| "How to find a job that makes you over 300K in software development" | 26 Jun 2009 23:17 GMT | 2 |
Attention Developers At last! Here are the (long overdue) tips and tricks you've been waiting for. Check out this new contrarian special report that reveals secrets of industry's highest paid programmers - the secrets you can
|
| COUNT(...) OVER(...) | 26 Jun 2009 18:59 GMT | 3 |
I'm trying to learn about analytic functions, more specifically the OVER() clause applied to COUNT() and AVG() functions. I've read the SQL Reference and I've found several examples in Google but I still can't grasp the concept.
|
| UNDO Issue | 26 Jun 2009 13:22 GMT | 14 |
We're receiving this message: . . importing table "DAILY_CONSENSUS_HST" IMP-00058: ORACLE error 30036 encountered ORA-30036: unable to extend segment by 8 in undo tablespace
|
| REGEXP_SUBSTR() is always NULL | 26 Jun 2009 08:23 GMT | 6 |
In an Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 server, REGEXP_SUBSTR() always returns NULL. E.g.: SELECT REGEXP_SUBSTR('1234,5678', '\d+', 1, 1) FROM DUAL
|
| Data type changes using ODBC... | 25 Jun 2009 09:26 GMT | 2 |
I am using Oracle ODBC to connect tables from an Oracle schema to an empty Microsoft Access DB. In one particular table i have a VARCHAR2 field that is 255 chars long. This field is reported as being of MEMO type in Access, which is untrue.
|
| Why I cannot do select on other's tables even when I have DBA privileges | 24 Jun 2009 22:42 GMT | 13 |
I have dba privileges; My database has users user1, user2… When I enter Select * from user1.table1 I get an error table or view does not exit, I am pretty sure table1
|
| [Oracle 9i] Is the script is the same as the interactive mode? | 24 Jun 2009 17:49 GMT | 2 |
I need to create a script exporting the database in exactly the same way as in interactive Exp in interactive mode: $ exp database_user/******
|
| Oracle reports 6i | 24 Jun 2009 11:43 GMT | 1 |
Learn Oracle reports in 2 days...I have described fully how to develop the reports..
|
| Airlines | 24 Jun 2009 11:34 GMT | 9 |
Site contain very much information about airlines inclouds coutry wise airlines companies informations and video see this # Pakistan Airlines
|
| Remove dupes with CLOB columns involved | 23 Jun 2009 17:10 GMT | 6 |
I've created a GLOBAL TEMPORARY TABLE where one of the columns stores the result of concatenating a variable (and unknown) number of VARCHAR2(100) cells. I didn't want to hit the 4,000 character limit when the source table has more than 40 rows so I created such temp column as
|