CLOB To BLOB

I want to read a clob data from table and post that value in blob data field of another table . How can i do this ? TableA (having clob data field F1) TableB (having BLOB datafield F2) update TableB set F2= (select F1 from TableA where condition1) where condition2. Here condition1 insures

RE: VMS equivalent of ls -lrt

Title: RE: VMS equivalent of ls -lrt Top Man Rich. Works well and a satisfied user for the first time in my career!! Nice bit of coding, especially the line formatting bit DCL is a nice language to work in I always found. Once you know what lexicals are available it is amazing what you

Connecting to Oracle from ASP ?

Hello; I am using the code given below to connect to Oracle using ASP. % Set DataConn = Server.CreateObject(ADODB.Connection) DataConn.Open DSN=ora;UID=scott;PWD=tiger Set DataCmd = Server.CreateObject(ADODB.Command) 'DataCmd.CommandText = SELECT * from emp WHERE ENAME = '

Re: Insert into ... as select ...

Hello, Effectively, your syntax perfectly function ... Thanks again ! Jean Berthold SIM/HAOUHACH a écrit : I think that it is possible to use the next syntax: insert into grandeur_mesure2 (ID_GRANDEUR,DATE_AQUISITION,VALEUR,VALIDITE,ID_TYPE_ACQUISITION,UTILISATION )

Re: Insert into ... as select ...

Hello Jack, because I have need to recover information of an existing table that had a field dates decomposed in field dates, field hour field times. I have need to recover all existing information in an unique field dates, in the new table... I hope that you will understand my explanations, my

Replication: general overview

Hi list, Does anybody know any links to docs that give a general technical overview of how oracle deals with replication ? I'm especially interested in a schema that shows what oracle-user is doing what in the process of replication. I've got it to work on our databases, and have made various

RE: Disk to Disk backups and RMAN

I have never trusted NT in my life and stay miles away from it..:) Have always been much more comfortable with good old Unix and good new Solaris.they provide a much more stable and trustworthy environment. Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED]

Re: lsnrctl error

Zsolt, message file not found errors are typically caused by: * incorrect env variable settings (especially ORACLE_SID and ORACLE_HOME) * invalid setting for NLS_LANG * permission problems * improperly linked executables to relink just the networking components: cd $ORACLE_HOME/bin

Re: ora-03113 ora-03114

Donnie, Core dumps on NT don't record any errors in the alert.log the way they do on Unix platforms. They will typically create a sidCORE.LOG file in either bdump, udump or the default %ORACLE_HOME%\RDBMS73\TRACE directory. If you're lucky it will contain a stack trace that might be useful to

RE: Disk to Disk backups and RMAN

Anytime LeeI learn a lot of things from you too, u know Will b glad to b of help. Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 -

Re: Connecting to Oracle from ASP ?

Hi, Check up if you are having Oracle client installed on the server(IIS) machine? It is a must to access Oracle from ASP. Regards, Prasad BAV. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 19, 2001 2:15 PM Hello; I am

RE: Replication: general overview

The oracle documentation is good -Original Message- Sent: 19 November 2001 09:50 To: Multiple recipients of list ORACLE-L Hi list, Does anybody know any links to docs that give a general technical overview of how oracle deals with replication ? I'm especially interested in a

RE: SQL query tuning problem

Title: Blank I have the first edition which is an excellent book but I cannot justify buying the later version - pity really -Original Message-From: SARKAR, Samir [mailto:[EMAIL PROTECTED]]Sent: 16 November 2001 15:50To: Multiple recipients of list ORACLE-LSubject: RE:

RE: Replication: general overview

Sorry, don't agree ... -Oorspronkelijk bericht- Van: Garner, John (NESL-IT) [mailto:[EMAIL PROTECTED]] Verzonden: maandag 19 november 2001 11:15 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: Replication: general overview The oracle documentation is good -Original

renaming Constraints

Title: renaming Constraints Hi list, is there any easiar way to rename a constraint other then dropping and then recreating it, cuz in our environment, developers mess up the constraints with naming them using system assigned names and then after finilizing the tables and relations, i have to

sequence of numbers

Hello, I've a table mt ( mt1 NUMBER(10) NOT NULL ) with unique index on the mt1 column. There's a sequence of numbers 1,2,3,4,6,7,8,10,11 ... in the mt1 Now, I want to get the smallest number which is not in mt1 (excluding min(mt1)-x of course) into XY (in my example is it n. 5).

RE: Oracle 8i Installation Problem

This is related to the symcjit.dll file being a pile of crap on a P4 type machine :-). What you need to do is copy the contents of the install CDs to your hard drive, then find the file symcjit.dll within the install set - it comes up a couple of times I believe.. Copy the attached version over

Re: sequence of numbers

select MIN(a.mt1)+1 INTO XY FROM (select mt1 FROM MT MINUS SELECT mt1-1 FROM MT) a; is better, but still full scan ... JP On Mon 19. November 2001 12:40, you wrote: Hello, I've a table mt ( mt1 NUMBER(10) NOT NULL ) with unique index on the mt1 column. There's a sequence of numbers

RE: Oracle 7.1 Listener question

If you find listener files in oracle installation then it is there otherwise not ;-)) I think it was there. I had worked with 7.2.3 and even now I can see some of them around. Listener is there. So I think even with 7.1 it would be there. Juck check the following dir,

RE: listener failed to start a dedicated server process

On NT, you may have run out of physical RAM. Oracle doesn't like virtual memory on NT. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch |

RE: renaming Constraints

Arslan, This is from the SearchDatabase.com DBA Tip Newsletter (www.searchdatabase.com). I haven't tried it myself though.. -- Renaming foreign keys By Terry Plantz Here is a script that renames foreign keys from system-assigned constraint names to more intelligible

Re: sequence of numbers

Maybe something like: select /*+ INDEX(a mt_ix) */ * from mt a where mt1 0 and not exists ( select null from mt where mt1 = a.mt1+1) and rownum = 1 where 'mt_ix' is the index on MT1. This should work ok as long as the number is anticipated to be toward the lower end of the range.

RE: VMS equivalent of ls -lrt

Now the last I heard, 8.1.7 would be the last release for OpenVMS. Has Oracle changed their mind? Will 9i be the last release? Hasn't Compaq decided to de-support VMS in the future? Gene *I say port VMS to Intel platform, then we will have Linux VMS as viable alternatives* [EMAIL

NLS questions

Title: NLS questions Hi list, I have some questions about NLS Parameters. I have a database created with following NLS parameters: NLS_LANGUAGE POLISH NLS_TERRITORY POLAND NLS_CHARACTERSET EEISO8859P2 My Client (Windows 2000, Polish) uses following NLS_LANG parameter

RE: Oracle 8i Installation Problem

Dear Mark, Your solution really works. Although I received the warning message of jrew.exe that some jvm.dll wasnot found, I could successfuly install Oracle 8i in my new computer after using new symcjit.dll. Thankyou very muck Mark.

RE: sequence of numbers

Are the numbers actually in sequential order in the mt1 column? If so, you could probably do the following: select m.row_num from (select mt1, rownum row_num from mt) m where m.mt1 m.row_num and rownum = 1; ...but it will only work if the values are actually in order for mt1. Jeffery

RE: Disk to Disk backups and RMAN

Samir, I totally agree with you - every single time I pcAnywhere in to an NT server, I curse! Unfortunately, it's sort of like a bad hangover that you just can't get rid of... Jim __ Jim Hawkins Oracle Database Administrator Data Management

FW: SQL query tuning problem

Title: Blank John, What has changed? I think we have both versions floating around here somewhere (unless one of the books left with some of our people). I'll try to take a stroll through the Table of Contents. Henry -Original Message-From: Hallas John [mailto:[EMAIL

Erroors in externel procedure trace file

PLSExtProc_agt_21994.trc : Remote HO Agent received unexpected RPC disconnect status 1003: ncrorpi_recv_procid, called from horg.c Anyone any idea what this means? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City

RE: Oracle 8i Installation Problem

Glad to hear it! Cheers Mark P.S. If I remember correctly Oracle will have installed its own JVM on installation so you shouldn't really have a problem with it. -Original Message- [EMAIL PROTECTED] Sent: 19 November 2001 13:50 To: Multiple recipients of list ORACLE-L Dear Mark,

Remote Links

Hi, I'm executing DML to three remote sites. The problem is that if there is a failure at a given site (i.e. the last site), the first two are commiting the transaction leavintg the third out of sync. We also noticed that the remote links stay connected. Shouldn't they disconnect after the

set_sql_trace_in_session

DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION isn't documented in the 8.1.6/7 doc sets. The package (and the procedure) exists, though even the package spec source code is wrapped. What gives? Is this package about to be desupported? Is there an alternative way of setting trace on in another session?

RE: VMS equivalent of ls -lrt

This is from an Oracle employee quoted from the Midrange Metalink forum: Oracle 9i is available for order in the U.S as of October 10, 2001. The part number that you should order is A91377-01. Of course, this *still* doesn't show up in the Product Lifecycle area in Metalink! :( Long live

Re: Remote Links

Rick, A distributed transaction normally uses the two-phase commit process so all sites should either commit or rollback. If there's a failure in one site then the RECO process should automatically recover the distributed transaction. Until it does this there will be info in DBA_2PC_PENDING

Long Column

Hi List, I have a question regarding moving a table with Long Column from one tablespace to another tablespace, any idea appreciate. I have tried this but doesn't work: ALTER TABLE TAB1 MOVE TABLESPACE NEW; Thanks in advance Hamid Alavi Office 818 737-0526 Cell818 402-1987 The

RE: set_sql_trace_in_session

Thanks. I'm looking at the online version of that manual, same part number, and DBMS_SYSTEM doesn't even appear on the list of packages: 52 DBMS_STATS Using DBMS_STATS Types Summary of Subprograms Setting or Getting Statistics PREPARE_COLUMN_VALUES Procedure SET_COLUMN_STATS Procedure

RE: applications patches

Title: applications patches I wouldn't try it. It could be a Client side patch. When searching Metalink put in your client hardware not your server hardware and see if you see the patch then. If not call support. -Original Message-From: Adams, Matthew (GEA, 088130)

RE: Replication: general overview

Remco, I'm inclined to agree with John on this one. For example, chapter 3 of the REPAPI manual discusses the setup of multi-master replication. Although the example it shows uses the REPADMIN user for all purposes, it explains that you can register different users to use as the propagator and

Load listener.log via sqlldr

Friends, Has anyone developed a sqlldr control file to load listener.log? I have a requirement to trap the IP addresses of failed connection attempts; this info is not trapped as an IP address in DBA_AUDIT_TRAIL or AUD$. If you have already accomplished this, let me know so I don't reinvent the

applications patches

Title: applications patches I just got a lovely requirement to patch an Oracle Purchasing instance. (Evidently, I'm suddenly an Oracle Applications DBA, how did that happen?) Anyway, the patch (2094819) appears to depend on another patch (2092683) that does not appear to exist anywhere I

database config assistant

hi, I've just installed 9i on RH7.2 but I can't find the appropriate script to start the Database Configuration Assistant (the jar files is in ORA_HOME/assistants/dbca/jlib but there are no scripts in ORA_HOME/assistants/dbca/install and ORA_HOME/assistants/dbca/) any hints? thanx, Marin

RE: Fwd: Extproc problem...

Try: ld -m /data1/dev/uexit/test/extproc.so -Original Message- Sent: Sunday, November 18, 2001 10:45 PM To: Multiple recipients of list ORACLE-L Hi, Pl use the equivalent of DLL walker of NT in Unix to find the exact name of the shared object that you have created. The shared object

Re: Rollback Segment Too Old !!!!!!!

The ORA-1555 is a read consistency error. The information from the rollback segments needed to create a read-consistent view of the data is not available. Usually because the information has been overwritten or the extents containing this information have been deallocated (e.g. if optimal is

Re: set_sql_trace_in_session

I would guess its because of the all the other goodies in that package. I believe the official way is to install DBMS_SUPPORT package (which you need to get from Oracle support), or use the oradebug commands from server mgr/sqlplus... But - easiest way would be to go on using dbms_system until

Oracle Forms Builder bug?

We have a problem on one of our development databases, whenever a developer loads a form into Form Builder in debug mode and executes it, the development database at the other end goes haywire: I ran the form in debug again, and the error happened again. Here are

Forms and Reports Server 6i minus iAS

Is it possible to install Forms and Reports Server 6i on Tru64 UNIX without installing iAS? Can't find any references to this in the Oracle Store. They only seem to be selling iAS with Forms/Reports bundled in it. Meanwhile the Developer Suite seems to have gone the way of the do-do bird, to

Discoverer on Citrix

Anybody successfully running the above combo without any major issues ? If so, what versions of Discoverer/Citrix/Oracle DB, what are your hardware specs and how many concurrent users ? TIA Srini Chavali Oracle DBA Cummins Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

MetaLink down?

Can't log into MetaLink. I can see the first page, but as soon as I click on Login to MetaLink I get this: The page cannot be found The page you are looking for might have been removed, had its name changed, or is temporarily unavailable. Please try the following: * If you typed the

Are corrupt index_partitions marked as unusable?

We have some block corruption on indexes in a copy of a database that was restored to an alternate host? Another DBA was concerned that block corruption was reported on these indexes but the DBA_IND_PARTITIONS view still reports these indexes as usable. Is database block corruption supposed to

Re: applications patches

Reread the patch readme.txt. The 2092683 is a prereq that is included in 2094819. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] MATT.ADAMS@AP

RE: MetaLink down?

I managed to get in, either because i now have to go through oracle.ca, or because they fixed the problem while I was clicking around. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]

RE: applications patches

Best to open a TAR and have Oracle support tell you what the required patches are. Patch information may not be on MetaLink. -Original Message- Sent: Monday, November 19, 2001 8:45 AM To: Multiple recipients of list ORACLE-L I just got a lovely requirement to patch an Oracle

RE: applications patches

Hi Matt, 'Patching' is the bane of the Oracle Applications world and not to be taken lightly. As for the question, you will not be able to apply the patch without previously having installed it's dependencies. Btw, which version of Apps are you at? Break out the docs - you are going to need

RE: set_sql_trace_in_session

Title: RE: set_sql_trace_in_session I'm in the same situation as Mr. Baumgartel. In the 8.1.7 documentation I searched for dbms_system and found four references: a)Oracle8i Reference under the SQL_TRACE initialization parameter b)Oracle8i Error Messages for errors ORA-29393 and ORA-29394

RE: Rollback Segment Too Old !!!!!!!

Another way of avoiding ora-1555 errors is issuing 'LOCK TABLE xxx in EXCLUSIVE MODE' before issuing a select statement. That will make sure that no transaction is modifying the table you're reading and you will not get any ora-1555 errors. This is especially useful in an OLTP environment.

PL/SQL, UTL FILE dynamic read v$parameter

Title: PL/SQL, UTL FILE dynamic read v$parameter Hello, Is it possible in PL/SQL to read v$parameter and pass the value for utl_file_dir to the UTL_FILE.FOPEN statement? This is my current attempt, and it's failing with the error, below. select value into v_utl_file_dir_name from

Re: Rollback Segment Too Old !!!!!!!

Hey Anita, this is really a cool workaround .. who thought these dummy transactions were so damn smart !!! this implementation of dummy Xns i am hearing about for the first time .. let me admit ;) Great mail!! Thx Deepak --- A. Bardeen [EMAIL PROTECTED] wrote: The ORA-1555 is a read

RE: Rollback Segment Too Old !!!!!!!

ok so let me chirp in as well .. another way of preventing 1555 is to first do a full table scan on the table you are about to mess with .. to prevent delayed block cleanout effect .. go figure ;) Deepak --- Gogala, Mladen [EMAIL PROTECTED] wrote: Another way of avoiding ora-1555 errors is

Re: Forms and Reports Server 6i minus iAS

Not as far as I know. You can only buy Forms and Reports Server by purchasing iAS Enterprise Edition. I would assume Oracle would only support them if you did the normal install. Technically, there may be a way to do your own install or to remove portions of iAS later, but that might influence

RE: PL/SQL, UTL FILE dynamic read v$parameter

Title: PL/SQL, UTL FILE dynamic read v$parameter Actually, what you want to do is specify the actual file name. Why worry about UTL_FILE_DIR? Oracle will automatically look into that directory for the specified file. You don't need to know the contents of UTL_FILE_DIR variable. Raj

RE: applications patches

Title: RE: applications patches Whoops... Ron is right. I read the readme.txt file too fast. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl)

Re: database config assistant

Hi, try $ORACLE_HOME/bin/dbassist /torben Marin Dimitrov wrote: hi, I've just installed 9i on RH7.2 but I can't find the appropriate script to start the Database Configuration Assistant (the jar files is in ORA_HOME/assistants/dbca/jlib but there are no scripts in

RE: PL/SQL package to emulate MySQL functions?

I do know that when I used Migration Workbench to migrate an Access database to Oracle, it created Oracle PL/SQL functions to emulate Access builtins that Oracle doesn't duplicate - (ANDN, CCUR, CDBL, CINT, DATEADD, EQN, ERIC, LEFT, RIGHT, TRIM, etc.) Maybe the MySql version of Migration

RE: PL/SQL, UTL FILE dynamic read v$parameter

Rajendra, This was received from you today in response to your email. ROR mô¿ôm [EMAIL PROTECTED] 11/19/01 02:40PM ___ ATTENTION!! _ A Virus Has Been Detected in the file attachment(s). The file attachment(s) have been removed by Guinevere, the Groupwise

RE: PL/SQL, UTL FILE dynamic read v$parameter

Title: PL/SQL, UTL FILE dynamic read v$parameter Linda: Try this: Enclose the string in single quotes, as: fileid0 := UTL_FILE.FOPEN(||v_utl_file_dir_name||, 'sequence_data','W') ; And consider thatutl_file_dir can have multiple paths, separated as utl_file_dir =

Oracle license historic price

Title: RE: applications patches Hi, Anybody happen to know what was the ratio between a concurrent license and named user license price, when oracle used to have those licensing models (before switching to famous UPU). I would like to see how fair is conversion factor of 2 that oracle now

RE: MetaLink down?

Works for me! I am in the metablink. -Original Message- Sent: Monday, November 19, 2001 1:40 PM To: Multiple recipients of list ORACLE-L I managed to get in, either because i now have to go through oracle.ca, or because they fixed the problem while I was clicking around. Regards,

Re: Fwd: Extproc problem...

Khedr, Waleed wrote: Try: ld -m /data1/dev/uexit/test/extproc.so -Original Message- Sent: Sunday, November 18, 2001 10:45 PM To: Multiple recipients of list ORACLE-L Hi, Pl use the equivalent of DLL walker of NT in Unix to find the exact name of the shared object that you

Re: Are corrupt index_partitions marked as unusable?

Have you analyzed the indexes in question? Isn't there an 'analyze index validate' command? --Scott Shafer Converse, TX [EMAIL PROTECTED] wrote: We have some block corruption on indexes in a copy of a database that was restored to an alternate host? Another DBA was concerned that

Solaris - db_file_multiblock_read_count

Hi. I was hoping for some confirmation here. I'm running 8.0.5 on Solaris 2.7, with block size set to 8192. There is no 'maxphys' parameter in /etc/system. After some testing, I've decided to set the db_file_multiblock_read_count = 24, based on the following: 1. SQL alter session set

Logminer Question

I'm analyzing archive logs from an 8.1.6.3 database running on Solaris. There are many entries in v$logmnr_contents with a NULL username and DATA_OBJ# and DATA_OBJD# values that don't match anything I can find in sys.obj$. What would account for these entries in v$logmnr_contents? Example

Re: Solaris - db_file_multiblock_read_count

That would appear to be sound reasoning. Be aware that high values result in lower costs for full table scans - which can give optimizer plans which are not desirable. You may also want to tweak some of the 'optimizer_' prefixed parameters if you find too much scanning going on. hth connor

RE: PL/SQL, UTL FILE dynamic read v$parameter

v$parameter2 will contain a row *per entry* which should make this process easier. hth connor --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: Linda: Try this: Enclose the string in single quotes, as: fileid0 := UTL_FILE.FOPEN(||v_utl_file_dir_name||,

Re: Solaris - db_file_multiblock_read_count

Or to continue this ... Why not set maxphys, any veritas related parameters if applicable, maxcontig on the file systems if appropriate and get the full 1M. Connor --- [EMAIL PROTECTED] wrote: Why not set it to 25? Jared

Re: Solaris - db_file_multiblock_read_count

Jeff, as jared pointed out already .. p3 for scattered read is the number of blocks read .. so setting your DB_Multi... to 25 would be the best you can achieve for your platform .. Deepak --- Jeff Wiegard [EMAIL PROTECTED] wrote: Hi. I was hoping for some confirmation here. I'm running

Re: Solaris - db_file_multiblock_read_count

Hi Jeff, I suspect that the size of the reads is based on the extent size within the table you're reading. I don't believe Oracle will issue a read across extents even if multiblock_read_count is high enough. The maximum limit for a read within Oracle has varied a lot with releases on Solaris,

RE: set_sql_trace_in_session

Steve, How about writing a PL SQL cursor to loop through all dedicated connections and then for each Sid, to use: SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(v_sid, v_serial, TRUE); Do a similar thing to turn it off. Bruce Reardon -Original Message- Sent: Tuesday, 20 November 2001

Re: Solaris - db_file_multiblock_read_count

It would appear that extent size does play a role in this. OS: HPUX 11.0 Oracle: 8.1.7 32-bit DB Block size 8k Setting multiblock read count to 1000 (v$parameter shows 128), then selecting against a table in an LMT: Case 1: Extent size: 128k max p3: 16 Case 2: Extent size 4M max p3: 128

Re: set_sql_trace_in_session

I haven't tried or tested this, but how about using an ON LOGIN trigger and selectively setting the event ? Regards, Denny Orr, Steve wrote: Hi Bruce, I thought of that but we have many VERY quick connects and disconnects (web application without persistent connections) so I'm not

RE: set_sql_trace_in_session

Steve, Why not put it in a logon trigger? Jared Orr, Steve

RE: set_sql_trace_in_session

If on 8.1.7 or greater, why not create a login trigger that alters the session? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] sorr@rightnow

Re: set_sql_trace_in_session

How about for your current session: ALTER SESSION SET timed_statistics=true; ALTER SESSION SET max_dump_file_size=unlimited; ALTER SESSION SET EVENTS '10046 trace name context forever, level 8'; Or for another user's session: SELECT s.username, p.spid FROM v$session s, v$process p

RE: set_sql_trace_in_session

Steve, What having a logon trigger that uses dbms_sql / exec immediate to do an alter session set sql_trace = TRUE The logon trigger could have some intelligence to only do this for the schema you want. I haven't ever done this on a production system for all sessions (but did get very close to