| Thread | Last Post | Replies |
|
| Oracle 8 drive configuration | 03 Jun 2005 16:48 GMT | 17 |
I am just in the process of purchasing a new server for our Oracle 8 database. Our current server uses RAID 5. I want to move away from RAID 5 for performance reasons. Does anyone have any configuration suggestions for 10 72gb 15k rpm scsi drives not using RAID 5.
|
| iSqlplus 10g | 03 Jun 2005 16:43 GMT | 3 |
I started iSqlplus for 10g aix fine. However, when i try to login in using http://<hostname>:5560/isqlplus, once I entered userid and password and click OK, there is nothing happen. What could go wrong? Is iSqlplus the only way to go for 10g. I just want to create a simple
|
| Servicios inician , pero no la base de datos | 03 Jun 2005 12:03 GMT | 3 |
Hola , tengo un problema con el Oracle 9i, lo instalo en 2003 server y los servicios arrancan bien, pero la base de datos no la inicia, hay que hacerlo a mano, ¿ alguien sabe porque me puede ocurrir esto ?, gracias
|
| Help with PL/SQL and XmlType | 03 Jun 2005 10:48 GMT | 3 |
Why does this? declare var XMLType; var2 XMLType;
|
| What to do? Many updates and selects | 03 Jun 2005 09:38 GMT | 4 |
Scenario 1: I am going to have a system where approx. 1000's of one line updates per second or one line selects per second can be expected on the oracle database software.
|
| OEM Node discovery OK, but not DB, or Listener. | 03 Jun 2005 07:41 GMT | 10 |
Strange issue. When logging into a local EM session can see a server and tables no problemo, however when logging into the management server, sysman, xxxx after discovering the node in question we do not see the database or listener. Any ideas ?
|
| Problem in comparison of two way records in table | 03 Jun 2005 07:26 GMT | 1 |
I have a problem with a table whereby everytime a record is created another is created showing the opposite of this: e.g. Rel_Id (PK)|Source_Id|To_Id|Start_Date|End Date
|
| RMAN archive log best practices | 03 Jun 2005 04:30 GMT | 4 |
Hello and thanks in advance for any help you can give. I am finally joining the world of RMAN and need some help determining the best way to handle the archive logs. The question is at the end, so please keep reading.
|
| Constrainting NUMBER | 03 Jun 2005 03:04 GMT | 9 |
Is it good to leave all numeric columns as NUMBER instead of specifying a precision, say, NUMBER(6,2). What are the pros and cons of the two approaches? At least, it seems that using NUMBER for everything simplified code modification in case we need to
|
| Does varchar2 size matter? | 03 Jun 2005 02:13 GMT | 3 |
What are the repercussions of declaring all strings varchar2(255) even if many will have lengths <=20 or <=30 (but none >255)? Is there any value declaring some to be varchar2(20) or varchar2(30) rather than just making them all varchar2(255)?
|
| Rman backup questions | 03 Jun 2005 01:36 GMT | 1 |
I have a backup going to disk. After a new backup is created the previous backup is sent to tape; BACKUP DEVICE TYPE sbt BACKUPSET COMPLETED BEFORE 'SYSDATE-1' DELETE INPUT; All of this is ok. But how would is get my database back to the current
|
| Dynamic XMLelement generation | 03 Jun 2005 00:50 GMT | 2 |
I have a very small question regarding Xmlelement function , can the XMLelement tag name can be generated dynamically (base on CASE expression / decode). I am using the new XSQL capabilities in oracle 9i and i failed to do it
|
| Need an ORACLE HR Admin in MIAMI, FLORIDA!! 85k + 20% Bonus + RELO | 02 Jun 2005 23:34 GMT | 1 |
HELP, I need an Oracle HR Functional Administrator in MIAMI, FLORIDA. I'm in DESPERATE need of this person!!! Drew Lauter
|
| Oracle 9.0.1.6 fails to use index with '=' but will with 'like' | 02 Jun 2005 21:53 GMT | 5 |
How is this select * from coneventnp where chcontainer like 'OLSU8888888' Uses the index on the chcontainer column, but select * from coneventnp where chcontainer = 'OLSU8888888'
|
| group by and sorting | 02 Jun 2005 21:41 GMT | 4 |
Is there a way to "tell" Oracle not to sort when it's doing GROUP BY? I think I saw something like ... group by nosort somewhere. Eugene
|