Oracle - Oracle database server topics

Thread preview

Thread	Last Post	Replies

9i runInstaller hangs - AIX 5.3 ML05	04 Apr 2008 16:41 GMT	7
I am pulling out what little hair I have left! I cannot get oracle to install on my AIX 5.3 Maint Level 05 box, the installer is very very slow, and hangs at different spots. The installler will say it is linking, but there are no ar, make etc.
ORA-27146	04 Apr 2008 12:31 GMT	2
I've installed oracle 10g on Solaris 9 sparc, my problem is when installed progress on Database Assistant to create database message error ORA-27146 :post/wait initialization failed, if i click ignore
External Tables (support DML)	04 Apr 2008 12:25 GMT	5
I have a question about Oracle and External tables. Does Oracle official support external tables? I read some articles that it is possible with some workarounds, but is it also supported by Oracle?
Slow data dictionary query from all_synonyms fixsyn script	04 Apr 2008 09:55 GMT	6
I've developed a script file which fixes (creates or drops) synonym statements for all users which have been granted access for current user's objects. It can even trace the privileges inherited through roles.
finding the next date	04 Apr 2008 09:27 GMT	2
I have the following problem. this is my data SEQ DATE 1 1-JAN-2008 2 1-JAN-2008
Static Select statements	04 Apr 2008 08:52 GMT	4
Is there a way to force a static row in a SELECT statement? For example, I have a SELECT statement which is a UNION of two identical tables, "A" and "B". How would one create a column which identifies the source table?
Pass a variable into procedure to use as column in select statement	03 Apr 2008 23:44 GMT	6
I'm new to PL/SQL and having trouble passing a variable into a procedure and using it as a column identifier in a select statement. I'm using this as a universal procedure to pass access information to applications based on user authorization.
How to make a dump for Oracle 9i with Oracle 10g	03 Apr 2008 23:26 GMT	2
is it possible to create an export dump of a scheme in Oracle 10g in order to import it into an Oracle 9i database? Thank you, Norbert
Large tables, updates, selects and varchars	03 Apr 2008 18:49 GMT	6
I am using Oracle 10g (10.2.0.3.0) and have a large table (1+ billion rows). It currently has about 15 columns in it. I have a requirement for a new varchar2(4000) column to go with the current data in that table. I need to update this column after it has been added to the
recovering lost tables from oracle9i database	03 Apr 2008 16:59 GMT	6
in my oracle 9i database,around 150 tables were created and used frequently. but one fine day,only around 20 tables are seen and other tables are missing. How can I recover all the other tables. The tables are all created by scott/tiger. pls help me out asp.
backup machine with 2003 and 10g , ASM and restore to another	03 Apr 2008 15:43 GMT	1
Have a customer wanting to 'ghost' a machine that has databases stored on an ASM partition. Is this easy?. I think what they are hoping to achieve is a clone for a remote DR site.
Oracle Logical Operator order of execution	03 Apr 2008 11:11 GMT	6
Oracle 10g R2 Win 2003 I have a select statement which is similar to select * from test
Compressing RMAN backups	03 Apr 2008 09:31 GMT	2
Our data center uses Netbackup for backups. I have to do RMAN backup over the wide area network which takes long long time. I am looking to reduce what is sent over the nework using Oracle 10g RMAN compression. My databases, however, are Oracle 8i based.
oracle 8i linux	03 Apr 2008 08:34 GMT	6
Does anyone have a copy of this I can download ? Oracle no longer offers this desupported product. Thanks !
Java store procedure that reference a external library.	03 Apr 2008 06:23 GMT	1
Hi. I have this problem. I can to compile a java store procedure that reference a external library. I tested this source in eclipse and execute correctly.