Oracle

• Oracle Questions

• • You will never be as smart as the Tom

    Gee.. not that /BIG/..The only GUI programmer in LRT for a while, but that and asix figuresalary wil...

    By tom_bishop_poetry_com

  • database version for compaq 4.0d

    Can someone tell me what kind of oracle database I can use on a compaq digital 4.0D?thankspedro...

    By brambilla_pietr_

  • "Connect By Clause" - Major Bug in Oracle ...

    Currently I am working with Oracle 8.1.6 database,now we are migrating to Oracle 9.0.1.We are often ...

    By patelmiteshh

  • "failed to convert view" message offers no...

    When trying to convert captured model to converted model, get "failed to convert view" for all views...

    By scottf

  • "alter database open" blocks (doesn't retu...

    I'm running a Solaris 8 machine with Oracle 10.1.0.2 as a development machine. I have the /opt/...

    By torypat

• • "Copy to file" in Oracle GUI is Disabled

    Hi!,Good Day! is there anyone here who can help me and explain to me whywhen i want to click the "Co...

    By nel, 1 Comments

  • You see Data via SQLPLUS but not via Application

    Oracle says when you partition tables you don't need to change any code in the application.I co...

    By chumkayz, 2 Comments

  • Database Upgrade

    Hi, Can anybody tell me what are the steps involved to upgrade Oracle 8 to Oracle9i. What are the pr...

    By james_ora_2004, 14 Comments

  • Datafile autoextension

    Is there a built in view that will tell you the last time a datafileautoextended?TIATo reply by emai...

    By chuck, 2 Comments

  • "ERROR: Unable to convert from "UTF-8"...

    Hi All;When I try to install Oracle 10G R2( 10202_database_HP-Tru64.zip ) with XWindows ./runInstall...

    By mennan, 4 Comments

• Oracle: is the Category's subject.It's has 291,700 questions,this is No.14,585 pages.
• datafile
• How to link back a existed table space datafile (*.dat or *.dbf) to the new created database instance ?...
• vivianlai, Fri, 12 Mar 2010 13:02:00 GMT, 103 bytes
• Case sensitive object naming in PL/SQL
• Hello,This is my first entry here.I would like to criticize criticism for case sensitive object naming in Oracle and PL/SQL.As you might know - Oracle is converting object names to uppercase by default. Whenever you create object likeCREATE TABLE my_table(my_column NUMBER);it would be created as MY_...
• indirapersand, Fri, 12 Mar 2010 11:28:00 GMT, 2,289 bytes
• Number of extents
• I am having a debate with a co-worker (who is also a DBA) in regard to the silly myth (in my opinion) that having more than one extent is a bad thing. My reasoning is as follows:So far as I know, there are only two ways Oracle accesses data in a table -- full table scan or by rowid. The manner in...
• indirapersand, Fri, 12 Mar 2010 11:25:00 GMT, 1,127 bytes, 2 Answer
• Datadictionary views Creation
• Hi all, I am Rajkumar.In my interview i faced a que like how do u create datadictionary views.Could anyone explain me how it works. We are not creating the views while creating database manually.Then how is it created through sql.bsq . could anyone please explain me how it is created.Thanks,Rajk...
• bang, Fri, 12 Mar 2010 11:17:00 GMT, 327 bytes, 4 Answer
• Database Writer
• How to add Database Writer processes into database.Thanks...
• user449027, Fri, 12 Mar 2010 11:11:00 GMT, 65 bytes, 2 Answer
• database version
• there scripts i can find it out database version.i have this one which don't tell me the database version.select * from v$version;...
• user473333, Fri, 12 Mar 2010 11:04:00 GMT, 143 bytes, 5 Answer
• DOWNLOAD THE MOST POPULAR 2005's CRACKED SOFTWARE(CAD/CAE/CAM/EDA/GIS/PCB/FEA/CNC/
• Our Team provide CRACKED engineering and technical software at this topics:=> Civil and Structural=> Survey , GIS , Rock , Soil and Water=> Architectural=> CAD-CAM=> FEA , CFD and CAE=> Electrical , Electronic , Control and Power=> Chemical=> Industrial and Control Projec...
• guest, Fri, 12 Mar 2010 11:03:00 GMT, 9,276 bytes
• Database Upgradation
• Hi,I have installed HTML DB on Oracle 9i relase 2 database. Can anyone pls advise if i upgrade my database to 10g ,will i have to re install the HTML DB or HTML DB will remain as it is.Regards...
• lagarwal, Fri, 12 Mar 2010 10:21:00 GMT, 204 bytes, 1 Answer
• "DBERROR db4: PANIC: fatal region error detected; run recovery" Error
• Hi forum,I am running postfix-2.2.10 with BDB-4.2.52-7.1 & cyrus-imap-2.2.12 on Redhat Enterprise Linux 4 update 4 on s390x(IBM Z series). After installing cyrus-imap & I am receving the following error in /var/log/maillog :Sep 12 13:09:50 linux08 imaps[16727]: DBERROR: critical da...
• user594800, Fri, 12 Mar 2010 10:04:00 GMT, 3,255 bytes, 1 Answer
• '!' while using the HTMLDB_MAIL.SEND package
• Hi,Someone please help me,I have this link that I send in my mail through htmldb.Now I call the mail package in the procedure as follows :HTMLDB_MAIL.SEND( P_TO => 'abc@oxyz.com', P_FROM => 'pqr@mn.com', P_BODY => v_adm_html||l_body_html, P_BODY_HTML => v_adm_html||l_body_htm...
• deepaj, Fri, 12 Mar 2010 10:03:00 GMT, 581 bytes, 1 Answer
• Database/Application Design Advice
• We have many custom applications that use similar data. One example of this data used across these applications is Item information. The way our applications are currently designed, each system has it's own schema and this item information is brought into each system. This method of design...
• janelson_hormel_, Fri, 12 Mar 2010 09:20:00 GMT, 1,202 bytes, 3 Answer
• Cloning an Oracle Home (10.2.0.1) Software does not work.. Any Idee
• Hello,I have allready cloned the Oracle10.1.0.2 Software with the oracle clone method.At this time i am trying the cloning with the new version 10.2.0.1.0 . But it does not work and I get the massages (see-log file):Does some one knows what has been changed with the new version 10.2 .?Or does it...
• user504326, Fri, 12 Mar 2010 08:46:00 GMT, 9,854 bytes, 1 Answer
• ORACM always FAILS one node - Oracle 9i rac -Sles9 - 9.2.0.8 ORACM
• Hi, I really need help with this. I applied all the patches possible. I tried sharing the quorum.dbf as a nfs device, raw device, iscsi lun ... i patched the ORACM to 9.2.0.5, 9.2.0.6, and now 9.2.0.8. The setup has two hp dl360 with sles9 sp2, x86_64 and oracle 9.2 rac... The problem is the clu...
• user558358, Fri, 12 Mar 2010 05:41:00 GMT, 23,513 bytes
• create table grants and Dynamic SQL question
• Hi,given 2 users a and b, I would like to do the following:connect a/password@instancecreate table b.test (x number);drop table b.test;Is this possible in Oracle 9.2, and if yes, which grants will I have to set?Is it furthermore possible to put it into dynamic SQL?DECLARECmd VARCHAR2(100);BEGINC...
• flamedance, Fri, 12 Mar 2010 04:54:00 GMT, 818 bytes, 5 Answer
• Database.count() performance
• Hello, could somebody please explain, how does method count() work?Does it iterate over all records in database, or there is some internal counter which is updated each time record is added/removed from database?...
• jdevelop, Fri, 12 Mar 2010 04:52:00 GMT, 220 bytes, 4 Answer
• Update with two subqueries
• Hi there,this statement doesn't work:update GFDXT_CLIENTES set CLT_NUMERO_CLIENTE_GEICO =(select COD_CORRECTO from LOOKUP, GFDXT_CLIENTESwhere GFDXT_CLIENTES.CLT_NUMERO_CLIENTE_GEICO = COD_ERRONEO)where GFDXT_CLIENTES.CLT_NUMERO_CLIENTE_GEICO =(select COD_ERRONEO from LOOKUP, GFDXT_CLIENTES...
• chicos54, Fri, 12 Mar 2010 04:50:00 GMT, 766 bytes, 2 Answer
• Database10g Rel2 Intallation Error i.e. ORA - 24324
• Dear All,I am trying to install Oracle 10g rel. 2 on Windows XP, But when the the configuration assistant installer tries to copy the db files, it stop with the following errors:ORA-24324 Service Handle not InitializedORA-24323 Value not authorizedORA-28547 Connection to Server failed probable O...
• user556901, Fri, 12 Mar 2010 04:10:00 GMT, 851 bytes, 7 Answer
• Database-related clip art / illustrations (royalty free)
• I need some database-related clip art / illustrations, preferablyroyalty-free. Failing that, I just need some good visual examples of anartsy, sketched-out database cylinder. I've tried the usual suspects,e.g. istockphoto.com but found nothing.Anyone hear seen nice illustrations / rendering...
• mikeerdas_yahoo_com, Fri, 12 Mar 2010 03:10:00 GMT, 599 bytes, 1 Answer
• DATABASE USER LEVEL SECURITY
• Hi All,There is requirement of implementing security policy on databse level.We are planning to change the main application user's password which is required by the application all the timeand each user will have its own users.I have created a read only role and i will assign users with thi...
• umair, Fri, 12 Mar 2010 02:16:00 GMT, 356 bytes, 1 Answer
• 11G - SuSE 10.3 x86-64
• 'c->xlib.lock' failed...
• user601365, Thurs, 11 Mar 2010 21:10:00 GMT, 31 bytes, 1 Answer
• «««145771457814579145801458114582145831458414585