Home » Network Pages

• How to ask questions in a forum Newbees and exp. people pay attention
  Newbie?s and exp. but lazy people pay attention Considering all the laconic answers and grunts that the newbie?s an...


• ? Is there a way to automatically execute a SQL script?
  I need to find a way to automatically make a script run against a certain instance on my dB. Is it possible? Is it ...


• ? and # simbol mixing up
  Hi there friendsI was wondering if anyone could shed any light on this problem.When I insert data which contains a ...


• ?DBW0: terminating instance due to error 472?.
  My windows db (9i) was terminated due to 472. I was able to restart the db but I have no idea why yet. Can anyone...


• _TRACE_FILES_PUBLIC INIT.ORA PARAMETER
  Hi Working on Oracle v8i 8.1.6.0.0 with OS as NT I have this query:1.Say My Application developers would like to ex...


• _system_trig_enabled = false?
  Oracle 9.2.0.8I am preparing to migrate a 9i database from DEC Alpha OSF 1, r1.1-8.1.0 to HP-UX B.11.23 U ia64.Due ...


• _optim_peek_user_binds
  Does anybody have any experience with the init.ora parameter "_optim_peek_user_binds" on 9.2? We're getting some f...


• _optimizer_cost_based_transformation = off _optimizer_push_pred_cost_based = false
  Hello,3 questions:1. What is the meaming of_optimizer_cost_based_transformationand_optimizer_push_pred_cost_basedpa...


• _gc_integrity_checks=false, meaning and effects
  We have upgraded our 3 node RAC from 9.2.0.3 to 9.2.0.5, A week later we updated our code then we started getting ...


• _disable_logging
  can anbody explain me what this parameter does? I researched oracle but I couldnt find much info on i.t ...


• [Urgent]Error Installing Oracle 9ias on Aix 4.3
  Hi All,I have been trying hard for the last couple of days to install only the HTTP option of Oracle 9ias on my AIX...


• [StandbyDB] shows logs in double, one applied, one not.
  I have multiple old logs that are always showed as non applied. (My actual sequence# is 11796.) The standby db is r...


• [SQL] Select Distinct Values from one Column and Output SQL to Multiple Columns
  DLA_PROFESSIONAL_A Table has many columns FIRST_NAME,MIDDLE_NAME, LAST_NAME, TITLE_CODE, COMMUNICATION_TYPE_CODE, C...


• [RMAN8i] Backups retention
  Hi everybody and Happy New YearI have the following problem : I want to delete some of my old backupsests. The scri...


• [Oracle 817 EE] default schemas and users
  hello guys,I installed a test server for an application, I created a database with the 8i scripts, but I have some ...


• [oracle 10g]Access rights after import
  Hello,I am a beginner with Oracle so I have a newbee question ... One of our customer send us an dump of his databa...


• [no text] : Pando, what about the rollup ??
  ? ...


• [HELP] IMP-00017: following statement failed with ORACLE error 4068:
  Running Oracle 8.1.7 on Windows 2000 x86 Serverand trying to import a schema dump I get the following error:What co...


• [email Server] Can't login in Thin Client with existing user
  Hello I've set up an iAS Email Server. It works when I try to send receive mail from the Outlook Express Client.I H...


• [817 NT] Error message when launching svrmgrl
  Hi all,I just installed Oracle 8.1.7 EE NT version on my notebook to see what it looks like. Installation was fine,...


• zip utility?
  Hello everyone,Does anyone know of any zip utilities that can work on 20Gigs+ files? I need a zip utility for any ...


• Zero or missing cardinality
  Hi,Could anybody explain in detail this output of Oracle Expert?:This table contains columns with zero or missing c...


• Zenoss
  Has anyone used Zenoss Enterprise Edition ZenPacks to monitor Oracle databases?We are looking for a management diag...


• YY dates comparing 2001 & 2099
  Hi,I hope someone can help me with this. I have 2 date fields that are FTP'ed from a main frame. The date format ...


• your problem : the tbs is dropped
  how to recover?? no archive no previvous backup( including export) have an old backup since 8 15...So use this o...


• Your Opinion: RMAN to tape or disk?
  My thinking is that if I write the backup sets to disk and then allow the media management software, a short time l...


• Your Opinion please
  We have a user that has a quota. This user owns two tables in the database. Every night we have some files come in ...


• Your opinion on the following design
  (Solaris 9.2) What is your opinion please on the following design? We are truly a hybrid implementation (as dict...


• Your Opinion - Disk
  (9.2 on Solaris)Our disk configuration is as follows. We have 2 logical disks each consisting of 4 physical disks ...


• Your favorite tuning paradigm ?
  I found a job that will give me all of the experience of a TUSC roadwarrior but without the road. Remote DBA for 30...


• your advice on 10g ASM configuration books
  Hi friends, Could you please tell me few oracle 10g books where we can configure ASM and install 10g RAC on windows...


• You know
  You can drop the column from your tableALTER TABLE EMP DROP(EMP_CODE); ...


• Yesterday's date cal in sun unix
  Hello I am using SUN Solaris 2.6Trying to calculate 'yesterday' date via shell program. I am using Bourne shell. Pl...


• year update
  I have a column with date 'mm dd yy'. Now I want to update year for the whole column from 2001 to 2002. How could...


• X_$???? Missing
  OS=> HP-UX 11.00ORA=> 8.1.7I seem to be missing certain x$ files ie. sys.x_$kglcursor,sys.x_$ksmspr,etchave they be...


• XOR 3 columns, one has to be set
  Hey there,I have to check via constraints if one of three references is set.For example: I have three columns, id1,...


• xmlparser installation for 817 on NT
  I need to install xmlparser into a database 817 on NT. please give me some instructions Where to find readme fil...


• Xmldb
  Working with XML DB.Has anyone been able to use partition tables on an XML DB?Thanks.Joseph ...


• XML-QL
  Is there any link or information on XML-QL ?Thanx ...


• xml to oracle
  does any body has experience loading data from xml files to oracle malutiple tables. ...


• XML storage in 8i - HELP
  Management have asked me for opinions on a proposed solution they're looking at. We currently runs applications bui...


• XML Storage as BLOB or XML
  What are the pros and cons of storing XML data (zipped form) in Oracle as a BLOB?So also, what is the advantage 'n ...


• XML Schema References
  I loaded an XSD into database table for validating incoming XML, but that XSD have an reference to another XSD.How ...


• xml question
  hai,Like in the XMLType column , i store the xmlformated data as such.And is it possible to query only required ele...


• XML parser for PL SQL in database
  Hi,Anyone can give what are the Risks and security issues involved while downloading and installing XML parser for ...


• XML files into Oracle Tables
  Is there any way I can able to load XML files into Oracle 8.1.7 tables( Win NT)?ThanksParesh ...


• XML Development Kit
  How to install XML Development Kit on a existing Oracle 8i Database?Thanks. ...


• Xml Db - 8.1.7.4
  Hi,I need to create xml db in an existing 8.1.7.4 DB. I am not sure whether xml db is available in 8i as I could no...


• XML data load using SQL*Loader
  Hi all,Can any one please suggest how to load XML data into a table using SQL*LOADER utility. Scenario is:I am get...


• XML and Jave in 8.1.6
  Hello,Is it possible to turn on XML and Java in 8.1.6 DB version? I remember reading some where that Oracle 8.1.7 ...


• XML and Heterogeneous Databases.
  Dears,I am working on XML and Heterogeneous Databases, Is there any one who has worked on it or want to share the k...


• XDB - XML processing (Anyone here using it)
  Just wondered about peoples experience with Oracle 9.2 XDB. I've been utilising it and was wanting to know other pe...


• XA Transactions
  XA Transactions Hi,I'm using 9.2 on solaris and try to connect from websphere 5.0.2 wich require XA transaction to ...


• XA protocol
  What is an XA protocol ...


• XA error in Oracle 9.2.0.4 Solaris 8 64 bit after DB restart
  HelloWe are getting following error when we restart database :racle.jdbc.xa.OracleXAExceptionatoracle.jdbc.xa.Oracl...


• XA drivers
  HiWe have C++ services published in tuxedo as backend which does database operations through Pro*C. The connection ...


• X11???
  I had installed 9ias902 on rh as2.1,all seem to be fine ,but when I reboot my compute ,I must excute a "xhost +"man...


• x.eye
  Can anyone forward documentation on x.eye.wealth.manager, especiallon installation on NT Unix, troubleshooting and ...


• x-window shareware
  We don't have terminal attached to our sun box. Is it still possible to connect remotely and run dbassist program. ...


• x$kcbcbh and x$kcbrbh views for db block tuning
  We are going to tune database by using x$kcbcbh and x$kcbrbh . But it's a heavy load production database , I am af...


• X$KCBCBH and X$KCBRBH
  Dear firends,I am not able to see the tuning tables X$KCBCBH and X$KCBRBH having logged in as SYS. Any reason why ...


• x$bh
  Hello,Is there any corresponding view or synonym availbale for sys.x$bh?ThanksNikee ...


• x$ tables views
  Can anyone suggest where I can find info on the underlying x$ base tables and views. ...


• x$ tables
  Hello,How can I list the entire x$ tables which are owned by SYS user?ThanksNikee ...


• X$ table
  Is X$KCBCBH and x$kcbrbhremoved from 8.1.7I am not getting X$ table in my database. ...


• X Dollors
  Hello,I would like to query the x$ tables ( ex: x$kcbrbh ), I logged in as "SYS", i couldnt query the table. What c...


• Wy this code fails ??
  I try pass the variable to my where clause but dosent work somebody knows as makes it?They see the example...The co...


• www.oracle.com: ORA-01403
  Check the error onhttp: education.oracle.com web_prod...?dc=D14309GC10Error is :ORA-01403: no data foundQuery is :...


• wwsec_persons$ problem when restoring full dmp of 817 portal
  Rebuilding a DOA windows 2003 oracle portal server using a full dmp file. When I create the db from scratch and imp...


• wrong user dump dest
  For some apparent reason, the .trc files are going into the default ORACLE rdbms log default directory.I set the us...


• Wrong Sysdate in the client
  I am using oracle 8.1.7 in Solaris. When I issued the sysdate command, it is returning two different value..From t...


• Wrong results with EXISTS after upgrade to 10gR2
  Hi, ALL : I?m facing (in a recently upgraded from 9.2.0.7 EE to 10.2.0.4 EE db, running in Solaris 64 bits) a very ...


• WRONG RESULT with range list partitioning
  Hi everybody,Could some one explain me why these 2 queries return a different result? I'm working on 9iR2 (9.2.0.5)...


• WRONG POSTING
  boss i am very sorry , i just posted a new question - IDLE TIME FOR USER - format , but in haste initially i poste...


• wrong output- 2 explicit cursors
  Hello, my problem deals with the use of 2 explicit cursorsthe code is displaying the wrong output. can you help me ...


• wrong index being picked up
  HiI have a query like Code: CREATE TABLE HRISHY PARALLEL 4 NOLOGGING ASSELECT SUM(POS_TXN_DTL_CUR.EXTND_SCAN_AMT) a...


• Wrong Group By Order
  Hi,I'm using Oracle 9i database.Here is my problem:When I select data from table using the first qurey the result i...


• wrong ELFF CLASS:ELFCLASS32
  Hi GuysI'am using oracle 9i with Sun solaris system.my database is down and when trying to logon and restart it; I ...


• writing scripts on Windows 2000
  Hi all,If I have my output spool out to to disk for example: spool c: temp test.txtI used scheduler tasks on Windo...


• writing script to connect database and execute sql
  How to write a shell script that connect to oracle database 8.1.7 as user xx xx executes below querysql>select eno...


• Writing Query
  Hi,I wrote this query to get to_unit_id,UNIT_CONV_FACTOR_NBR ============================...


• Writing Pl Sql program using Table of records
  Hi, I need to migrate a table from a production database into another production database. This table is a huge tab...


• Write Picture Object into BLOB Column?
  How to Write Picture Object (let's say 1.JPG) into BLOB Column?Could anyone provide the example coding ? ...


• Write option on Raids???
  Okay, trying to remember one of the WRITE parameters that we want disabled on a RAID setup. This is the parameter ...


• wraps in rollback segments
  Hi friends,I have rollback segments which are undergoing wraps,but the extents do not extend.Could u please let me ...


• wraps
  anybody can tell me when does wrap means and when did it happen (v$rollstat) ? ...


• Wrapping??
  Hi,Is there a possibility of wrapping a comple table having data like wrapping a procedure function or package???...


• wrapper question
  Hi GurusCan some one clearly explain to me what is meant by a wrapper? For example, what is meant by a wrapper scri...


• Wrapped proc func shows default values in clear text?
  Hello :I have a package body with two functions defined for encryption and decryption (using dbms_obfuscation_toolk...


• wrap
  anybody knows how to wrap a trigger???? ...


• Wow, I'm a senior member Worship me
  I feel like I just got a promotion Ahem...I'd like to thank the academy, my parents, the good lord above, but most ...


• would like to ask how to start OMS on oracle 9i
  im trying to start OMS on my home pc.it has a windows xp OS.i cant login to OMS. i type my pc's name on the login s...


• would index be used?
  If I create a concatenated primary key on COLUMN_1, COLUMN_2, COLUMN_3, COLUMN_4and I have a select statement that ...


• Worst Query
  How can I find out the worst query in the database?and other question...Is there a way to hide a PL SQL code?Thank ...


• Works in one user not the Other
  Hi, BROKEN is a DMP from a 8.17 DB setup by Client A, WORKING is a DMP from 8.17 DB setup by client B.Running i...


• Working with date time in milli micro nano seconds
  Hi All,Can anyone of you tell me the if there is a way to obtain time in milli or nano seconds? thanks ...


• Working with clobs
  HelloI am working in a project in which CLOBS are being used extensively. Specially there is a table whose size mig...


• working slow due to partitions added
  hi all,we are using Oracle 8.1.7 Form 6ion W2K server.We are using Commercial package for steel manufacturing ind...


• Working set of Oracle
  RDBMS Version: 816 EEOperating System and Version: Win NT 4.0 EEError Number (if applicable): Product (i.e. SQL*Loa...


• working Rollback statements in the application
  Hi,My question is below inside the PL SQL constructs.BEGIN FOR cust_rec in cust (4 records have to be process) LO...

Free eBook - Interview Questions: Get over 1,000 Interview Questions in an eBook for free when you join JobsAssist. Just click on the button below to join JobsAssist and you will immediately receive the Free eBook with thousands of Interview Questions in an ebook when you join.

• Free Tutorials - HTML, Java, SQL, PHP, ASP, Perl, SQL Tutorials
• Discuss Programming Problems and Freshers Jobs related issues here.
• Discuss Final Year Project Ideas here.