Oracle Database Forum

Hi, Is it at all possible to insert BLOBs using the Array Interface? Today I have an application using the array interface. It works fine but so far I haven't been using BLOBs. I insert 100-200 rows in one server round trip. Now I want to have one or more colums of type BLOB but I cant see how this can fit into my current application.

Hi, I would like to know how to insert multiple rows into a table, using a single INSERT statement. My requirement is like this I have a table ABC which contains multiple employees entries with empId as the primary key. Now I want to insert the all the empid multiplied by X and y (<EMPID>*x*y) into a table DEF plus filling other columns for...

Is there anyway of eliminating duplicate entries as the database loads data using SQLLDR and/or .ctl (Control File)? I use the following command line using SQLLDR and a control file to load my data, but the sample.dat file has duplicate information. I would like to be able to eliminate this, since I have know ability to manipulate the...

I am not sure if this is right place but I am preparing for Oracle Certifications, already did the first one for the OCA and a friend recommended practice tests from www.wise-men.org which I used for the preparation aside the Oracle press books. I am about taking Database Fundamentals I, does any of the gurus here have any advice? I have the...

Hi, I am suppose to do some capacity planning for my servers. I am quite new into this area, is there anyone out there who can give me some guide for a kick-start or is there any resource out there I can refer to for a clearer picture? I won't be using any 3rd party s/w in this case. Thanks in advance for any input.

Hello All, We are currently looking into archiving our production system. I have looked into several different options to accomplish this, and Oracle Replication is one of them. Can anyone give me any info on Oracle Replication? We currently have Oracle 8i, and it comes with the GUI interface Replication Manager, which we would be...

Can anyone help me to solve these problem, when i add a data block on oracle forms developer9i i always see these error... thanks you........ -- Posted via http://dbforums.com

Please ignore this

Hi. Our company has about 20 application developers/architects and one certified dba. Our developers both design the databases and build the applications. We're confused about what permissions a developer is supposed to have. On the one hand, we obviously don't want developers to have privileges like shutting down the db. On the other hand,...

Hello, I'm writing a java application with corba. The java class, which should be loaded in Oracle database, can create corba object and will be invoked by a trigger. Does anyone know if it is possible? Best regards Lucia

Hi, I was told there is a feature in Oracle to set up a table to have a limit on the maximum number of rows in it. By attempt to insert more rows, the oldest rows should get deleted automatically. Is there a way to do it, other than writing my own insert trigger? Thanks,

Hi, We've just started evaluating the Data Direct ODBC Oracle driver and comparing performance with Oracle's own driver in a development project we're undertaking. We have struck a problem - functionally the driver's working OK, but we have a performance problem that is associated with the ODBC connectivity layer.

I currently have return characters in my address text columns in my Oracle db. This is not good for us. Can anyone tell me how to query for these? I am trying to use a replace statement to replace with a space but having no luck using chr(13). Thanks, -Dan

What are the steps to export/import a database? -- Posted via http://dbforums.com

I am getting a strange symptom: tnsping and sqlplus work fine on my LINUX server (neo) so the listener and DB are OK. However, from my remote XP Client (tank) I get TNS-12560. I can ping the neo from tanks and tank from neo so it isn't a network problem. The trace file shows that in can't start the transport layer due to an error 530: ...

Hi, I am using dbms_metadata PL/SQL supplied package to extract all the objects from the oracle database into files. So far I have generated the source code for Functions & Triggers. Functions seems to be absolutely fine. But there seems to be some kind of a problem with Triggers. Some of the triggers were'nt extracted completely and some...

Hi there, Looking for a way of returning the Xth to Yth records of an Oracle database I thought using ROWNUM. Here is the solution I came up with. SELECT * FROM ( SELECT ROWNUM RECID, t.*,

Hi , Oracle 8.1.7.0.0 on HP-UX 11.0 I am a newbie as far as PL-SQL is concerned . I have Sybase/MSSQL T-SQL background. We have a report which uses a select statement . This select statement joins 15 tables . SOme of the tables are outer joined. It runs much slow when parameters (From & To Date) are for a month.

I am planning to take iz0-007 exam. I am very familiar with the syntax of oracle and I studied the 8i book written by Couchman and now I want to buy some self-test software. From Oracle site I went to the Kaplan site and they charge $99 for the test and then I found a test in the following site for 40 dollars. Are they both same? Any help...

There is a setting in INIT.ORA that has the unintended side-effect of making sure the ALTER SYSTEM KILL SESSION command has immediate affect. Without this setting, I've seen some instances where the session reports as being KILLED in V$SESSION but is not physically removed until the instance is bounced. Does anyone remember this value offhand?

Hi All, I created a script to defragment a database. To test this script I need a fragmented database. Does anyone knows a way to fragment a database easily? Thanks in advanched, Janneke

Will Oracle really make Linux "Unbreakable"? Raul Hormel Oracle Database Administrator Texas Higher Education Coordinating Board raul.hormel@mysterio.thecb.state.tx.us

Hi, I have the following SQL that I want to use to update a table. It doesn't work ! Does someone knows why? ** I Know it could be done easy with a CURSOR FOR LOOP, but still... Thanks for your help. update XSORA1A.XS0011T_STATISTIQUES_UNIX a

Oracle 9. Trying to put a constraint. The date_time field in table Visit should be >= than date_admitted field in table Admission. CREATE TABLE Visit ( adid INT REFERENCES myAdmission(adid), date_time DATE CONSTRAINT date_time_limits CHECK (date_time >= ALL (SELECT date_admitted FROM Admission, Visit

hi all, does red hat linux 9 support hyperthreaded p4 systems? if i install oracle 9i on a rehat linux 9 hyperthreaded system, can i see that as 2 virtual processor from oracle's perspective? can i use oraclel's parallel features with these virtual processor? tnx, ks