Oracle - Oracle database server topics

Thread preview

Thread	Last Post	Replies

How do I rename the storage area of a nested table?	29 Jul 2005 02:43 GMT	6
I have a nested table that I need to rename. How do I do it? Here is the abbreviated DDL: create table t_some_table ( ...
Question - RMAN 8i - Catalog or control file?	29 Jul 2005 00:56 GMT	2
Hey, all. I'm configuring RMAN under 8i (AIX 5.2), and have been told by my team lead that the preference is not to use a catalog, simply because it's just one more point of failure / db to back up / etc.
Purchasing Oracle 9i options	28 Jul 2005 23:57 GMT	3
I need to purchase 9i for testing purposes. It needs to have capabilities of the enterprise database and will be installed on a single-processor Linux workstation. I found "Oracle Database Personal Edition" on oraclestore.oracle.com
Count in SQL	28 Jul 2005 23:11 GMT	2
SQL newbie alert I have 2 tables, and I need to write some SQL to output counts of various entries. I've managed to kind of figure out how to proceed when only one thing needs
oracle designer-timestamp-date	28 Jul 2005 22:11 GMT	2
I use desinger to generate ddl script. in some tables, I have table column using timestamp, but in generated ddl, all timestamp type became date, anyone know why? and how can I fix it? oracle design editor 9.0.4.3.1.4 Thanks a lot.
Basic Oracle Concepts	28 Jul 2005 21:08 GMT	14
Sorry for this, perhaps, silly questions. I just started learning Oracle (9iR2) and is still trying hard to master the basic concepts. I went thru a few documentation (DB Concepts, 9i Getting Started for Windows, Administrator Guide, Instructor Led Training material, etc) and ...
resize tablesepace temp	28 Jul 2005 20:21 GMT	1
Hello greetings to all I am a little inexperienced and I need your aid... How can I compact the size of tablespace temp? thanks
Example for Advanced Queue	28 Jul 2005 20:16 GMT	3
where can I find a sample for enqueuing and dequeuing of messages by correlation and message id using PL/SQL? I found only using Pro*C/C++ and OCI and it is not clear for me. Thanks in advance,
cpu hogged at 100%	28 Jul 2005 20:15 GMT	8
I just installed Oracle 10g home on my machine : win xp pro sp2 RAM 512 DDR cpu : 2800+
Oracle UTL_TCP	28 Jul 2005 19:29 GMT	4
Im currently building a website and it will handle estimately 5,000 credit card transactions a day. Do you think its okay to use UTL_TCP to communicate to our credit card server to send authorization request. Is there a limitation in terms of
resize tablespace temp	28 Jul 2005 18:43 GMT	2
Hello greetings to all I am a little inexperienced and I need your aid... How can I compact the size of tablespace temp? thanks
PL/SQL: Is a CURSOR always Dynamic SQL ?? (pls-00455)	28 Jul 2005 17:53 GMT	8
I have a Oracle 9i database here. When I try to open a cursor FOR a cursor variable, i get the error: <PLS-00455: cursor 'X_SMDACUR' cannot be used in dynamic SQL OPEN statement>
emctl appears to need $DISPLAY	28 Jul 2005 17:32 GMT	8
I am attempting to write a script to bring Oracle 10g up and down. At one point I call "emctl start dbconsole". I find that it appears to need to have the DISPLAY environment variable set to a valid X server.
Oracle 10 : big difficulties : bad order in select result	28 Jul 2005 16:57 GMT	6
Oracle 10 is not stable and the kernel of the database engine contains a critical BUG : the result of a select can invert two columns compared to the request. The same code in oracle 9 do not produce the BUG. In order to reproduce this BUG, 2 select must load most of the columns of
How To Compare Date with Just the Day of Month	28 Jul 2005 14:38 GMT	4
I have the following date inserted into a DATE field: 07-26-2005 21:00:00 I have some code where I want to see if this date is equal to 07-26-2005, regardless of the time of day.