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...

waris29

04-04-2008 06:31 AM
Mladen Gogala

Hi all, I have a question about Oracle and External tables. Does Oracle official support external tables? I read some articles that it is possible...

SePp

04-04-2008 06:25 AM
Shakespeare

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...

OutCast

04-03-2008 05:22 PM
sybrandb@hccnet.nl

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...

chrism778@gmail.com

04-03-2008 12:49 PM
joel garry

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...

anujith72@yahoo.co.in

04-03-2008 10:59 AM
Mark D Powell

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...

GPD

04-03-2008 09:43 AM
GPD

Oracle 10g R2 Win 2003 I have a select statement which is similar to select * from test where a = v_number or b between v_date_low and v_date_high;

Wally

04-03-2008 05:11 AM
Shakespeare

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...

zigzagdna@yahoo.com

04-03-2008 03:31 AM
Mladen Gogala

Does anyone have a copy of this I can download ? Oracle no longer offers this desupported product. Thanks !

aaron.phillips@gmail.com

04-03-2008 02:34 AM
timo

Oracle 10.2.0.1 EE on RHEL 4 We have a very large table which is partitioned by range and then further sub partitioned by list. All indexes have...

mccmx@hotmail.com

04-02-2008 10:21 PM
madhusreeram@gmail.com

Oracle 9.2.0.6 I've got a materialized view based on a view: create materialized view mv_pra_ret_bcret_view build deferred refresh complete as...

steph

04-02-2008 09:33 AM
steph

Can someone share a link that will make this beast easy to understand for users of a superior product :) Particularly interested in 'how to tune',...

NetComrade

04-02-2008 06:15 AM
Shakespeare

If I do an explain plan of the statement below I can see that the "and" clauses that have MMDDOB=NULL do not get executed select * from v_search...

Arthernan

04-02-2008 04:39 AM
Shakespeare

Perhaps a bit too much, if you get my drift. http://members.aol.com/annika1980/ohdaddy.jpg

Annika1980

04-02-2008 04:03 AM
Shakespeare

On Apr 1, 10:12*am, "paul" <nom... (AT) nomail (DOT) com> wrote: No, since you still have updates which could occur. I believe your current setting...

fitzjarrell@cox.net

04-01-2008 03:26 PM
fitzjarrell@cox.net

Often the archive log destination is not really meant to be able to hold a week worth of logs. How can we redirect media restore to some temporary...

NetComrade

04-01-2008 03:07 PM
NetComrade

Cary Millsap leaving Hotsos and starting a new company? http://carymillsap.blogspot.com The timing is extremely conspicuous. We all remember Tom...

Mladen Gogala

04-01-2008 02:35 PM
hpuxrac

Hi, I'm posting this question again because after 30 minutes my last post did not appear, so hopefully this one will. How can I resize a redo log? ...

Mtek

04-01-2008 09:17 AM
gazzag

Hi, I'm posting this question again because after 30 minutes my last post did not appear, so hopefully this one will. How can I resize a redo log? ...

Mtek

04-01-2008 08:49 AM
Mtek

Hi, We need to resize our redo logs. They are already 50M and we have 3 groups, but the 'Checkpoint not complete' errors just will not go away. I...

Mtek

04-01-2008 08:49 AM
gazzag

How to measure the I/O response time of a multi-block reads from SQL trace file or OWI? e.g.. nam='direct path read temp' ela= 9291 file number=9999...

maks71@gmail.com

03-31-2008 04:44 PM
maks71@gmail.com

Hi, I've a problem with default value of integer data type: my software work fine with oracle version 8, but fail with 11g version. The problem is on...

web.Hunter

03-31-2008 03:25 PM
Frank van Bortel

Hi, I'm a beginner Oracle DBA who is facing a performance issues on a 9i instance running on Solaris. The db instance hosts a number of web...

Johne_uk

03-30-2008 12:20 PM
Charles Hooper

I know that jdbc can call a pl/sql package or procedure,but if i want to call a pl/sql anonymous block, how can i do it? no procedure name or package...

code

03-30-2008 09:50 AM
Vladimir M. Zakharychev

Hi, (DB10.2.0.3.0, AIX5L) I am reading by a SQL select statement from a parallel table. I get "ORA-12801 ORA-32696 HTI NO FREE SLOT" and Metalink...

ErikYkema

03-30-2008 08:24 AM
Mladen Gogala

Please help me to write query like this WITH table_not_empty AS ( if (SELECT * FROM Table1) is not empty return it_self else return (SELECT * FROM...

nova1427@gmail.com

03-30-2008 08:13 AM
Mladen Gogala

Hopefully, I frame this problem/question correctly. I have some code written/updated in visual studio 2003. This code when setup on other machines...

BookerT

03-30-2008 06:28 AM
BookerT

Solve your problem regarding Database Administration at http://www.admin.net.in

admin.net.in@gmail.com

03-29-2008 02:59 PM
Ana C. Dent

http://languages-languages.blogspot.com/2008/02/oracle-essentials.html

rommy

03-29-2008 10:59 AM
rommy

I didn't find anything on metalink but maybe was distracted? Curious as to when oracle may or will start shipping a patchset for 11g database...

hpuxrac

03-29-2008 10:00 AM
DA Morgan

Hi, We are trying to see what the optimal size of our redo logs should be and how many we should have. We are running 10g, and we know that there...

mtek@mtekusa.com

03-28-2008 06:16 PM
hpuxrac

I wont to create a datawarehouse in a 8 processor server. What kind of certificates do I need???

urian.bardulla@gmail.com

03-28-2008 05:55 PM
DA Morgan

Is it possible to export and then import specific sys objects without doing a full import? Basically my aud$ table got really large and made my...

jernigam@nospam.kochind.com

03-28-2008 01:13 PM
sybrandb@hccnet.nl

Dear Users, Kindly help me with below query of mine. For a web application, which is a suggested combination...

Hardesh

03-28-2008 12:49 PM
Frank van Bortel

HI, I want to build a oracle datawarehouse into a machine with 8 processors, what oracle certificates do I need. Thank you in advance,

urian.bardulla@gmail.com

03-28-2008 10:35 AM
fitzjarrell@cox.net

I want to recognize alpha values buried in varchar fields. 5555X5555 = hit 5555555 = no hit select * from table where to_number(field) is not...

md

03-28-2008 09:46 AM
md

Hey all: Servers -- solaris/aix any OS DB -- 9.2. & 10.2 What are others doing in setting "timed_statistics"? TRUE? FALSE? Obviously it's...

Pete's

03-28-2008 06:55 AM
Pete's

Hi, Is there a way to speedup this query ? (XIF705PF_REVISIONHISTORY is an index on transactionid ) Thanks for your help ... (10.2.0.3) SELECT MAX...

astalavista

03-28-2008 12:52 AM
sybrandb@hccnet.nl

10gR2 Schema is NOT registered with XDB. I have simple queries like this to extract value from SMALL XML doc passed in as CLOB: SELECT...

webtourist

03-27-2008 11:19 AM
webtourist

We have Oracle 9.2.0.8 on Solaris 8. I was wondering whether there was something similar to "top" for Oracle to display what it's doing at the...

kerravon

03-27-2008 10:21 AM
joel garry

I'm in the process of upgrading several 32 bit 9i oracle homes to 64 bit 10g. My plan is to install 10g into a new home first then one by one upgrade...

Chuck

03-27-2008 09:18 AM
Chuck

Dear gurus, Can vpd running on Oracle 10g Personel Edition ? Thanks,

pejantan4u

03-27-2008 07:11 AM
fitzjarrell@cox.net

10.2.0.2 EE, aix 5.2 64bit, oem 10.2.0.3 I've noticed several metrics that get reported in OEM with values over 100% One in particular is CPU I/O...

Ben

03-26-2008 12:44 PM
Ben

"Dereck L. Dietz" <dietzdl (AT) ameritech (DOT) net> wrote in news:0g1zj.10400$5K1.9452 (AT) newssvr12 (DOT) news.prodigy.net: 03135, 00000,...

Ana C. Dent

03-26-2008 12:13 PM
pgowar@gmail.com

Hi, I'm confused; please advice me how to import single user from a dmp-file to DB where that user simply does not yet exist ? I'd rather not like...

timo

03-26-2008 11:16 AM
joel garry

Hi, We have a table named "user", and want to determine how many records in the table have one or more upper-case characters in the "name"...

ohaya

03-26-2008 10:58 AM
ohaya

I thought I had donw this before but cant see a way how. Am sure I once opened a table and amended some data. Anyone know if possible or how, any...

GPD

03-26-2008 09:15 AM
GPD

I thought I had donw this before but cant see a way how. Am sure I once opened a table and amended some data. Anyone know if possible or how, any...

GPD

03-26-2008 09:15 AM
GPD

I thought I had donw this before but cant see a way how. Am sure I once opened a table and amended some data. Anyone know if possible or how, any...

GPD

03-26-2008 09:13 AM
GPD

Hi, Has anyone an Oracle Admin Lazy dog, please? Best regards, Mohsen

Mohsen Lashkariani

03-26-2008 05:53 AM
Steve Howard