Re: archiving data

Sai,   Thanks for the document information. The documnt indeed points that the max size of a LONG is 64K, yet my testcase proved that more than 64K is copied without incident. My test case used Tru64 Unix 5.1A and 8.1.7.4.   Using your data, please copy the long columns and check if the data

RE: use of reverse key index,cost based optimizer

Jared Like you, I have always understood that b+ tree indexes maintain their balance automatically. The statement I was referring to is in the Oracle9i Database Performance Planning manual, Chapter 1: "Use of sequences, or timestamps, to generate key values that are indexed themselves can lead

TERM LICENSES - ANY Experience

We are concerned on licensing especially as we are setting up a Disaster Recovery Site. During our Investigation it seems that TERM licensing can come out cheaper. Anyone have any idea on this or any disadvantages of leasing the software as opposed to owning it, thanks Sam -- Please see the

Re: archiving data

thanks a bunch for this test case...it surely will help me a lot   saiArup Nanda <[EMAIL PROTECTED]> wrote: I just did a few tests with a LONG field in a table. Final Answer: data morethan 64K is properly loaded using COPY.Test SetupUsed a plain text file, s.dat in unix with 97885 characters (97K)

Re: use of reverse key index,cost based optimizer

Skewed, yes. Unbalanced, no. Jared On Saturday 31 May 2003 00:34, [EMAIL PROTECTED] wrote: > Assume an index on employee number. The number is assigned sequentially, > and as such, the rightmost index leaf block would always be used. A > possible hot block. A reverse key index can avoid this. A

Re: quickest method

Thanks Mladen, I was just gonna ask that question. Didn't know that particular trick. Jared On Saturday 31 May 2003 19:48, Mladen Gogala wrote: > How do you set pipes accross the network? Using rsh/remsh, of course! > dd if=expdat.dmp|rsh node2 dd of=/tmp/expdat.dmp > > It doesn't matter if "ex

Re: archiving data

hi   i read thru this document id # 1022033.6 in metalink which says the follwoing Use the Copy Command with Longs and Long Raw:   The COPY command is one way to get long data from on

Re: archiving data

I just did a few tests with a LONG field in a table. Final Answer: data more than 64K is properly loaded using COPY. Test Setup Used a plain text file, s.dat in unix with 97885 characters (97K) . Created a table LT3 with only one field COL1 LONG. Used SQL*Loader to load the data into the table. T

RE: archiving data

Paula - Sorry to hear you are having problems. Since your posting time was last night, hope you fixed the problem in time to have a weekend with your kids. I get hit by the same thing now and then. You are right that you want to see your family, but when you are tired and grumpy they may not enjoy

Re: archiving data

Sai, Where did you find that limitation of 64K? Although I admit I have not used a long column of that size, but according to the fine manuals, the max size of LONG column copied is 2 GB; actually 2,000,000,000 bytes, not 64K. You have to specify the size of long in your session using SET LONG 200

Re: Parallel Query Server died

This server is dead. It has gone to meet its maker. It is no more. It's pushing up the lillies... This... is an ex-server. Thanks to Monty Python. Jamadagni, Rajendra wrote: Funeral at 8pm EST, movie at 11pm EST on TNT ...   Raj -Original Mes

Re: RE: Oracle 11i new features

Better still!! Maybe they will call everything (database/iAS/JDeveloper/IDS) 11i :) Cyril On Sat, 31 May 2003 John Kanagaraj wrote : >Nope! - Oracle 10i will be the end of the world (as Oracle knows >it at least >:) since we already have an Oracle 11i (aka Oracle Applications >11i - but >gen

Re[2]: Need Help for 9i OCP

Saturday, May 31, 2003, 2:44:41 AM, you wrote: RD> Simply go to RD> http://testprep.selftestsoftware.com/W4RT052EB6F8A396076E3EEF0024 RD> and your discount will automatically show on all individually RD> packaged products on the site. I looked at this. Their regular price is $99.00. As I recall

Re: quickest method

How do you set pipes accross the network? Using rsh/remsh, of course! dd if=expdat.dmp|rsh node2 dd of=/tmp/expdat.dmp It doesn't matter if "expdat.dmp" files on both nodes are pipes. On 2003.05.31 19:04 Babette Turner-Underwood wrote: > Sorry about the late response - - - Catching up > > Do yo

Re: Oracle 9IAS

Are you trying to install on a P4 system? If so, check metalink for installer crashes on P4 systems. It's a symjit.dll issue. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan

RE: archiving data

Sai I would research that before making an assumption. The COPY command is a bit different from anything else in Oracle. I found the following note with a quick Google search: "Note that sqlplus COPY has a port specific limit on the maximum size of LONG you can copy. Refer to the SQLPLUS Us

RE: quickest method

Sorry about the late response - - - Catching up Do you remember the syntax to do this? How do you set up UNIX pipes across a network? Thanks Babette -Original Message- Greenfield Sent: Thursday, May 15, 2003 2:02 PM To: Multiple recipients of list ORACLE-L For a two terabyte data tran

Re: archiving data

but i think there is a sqlplus limitation of 64k and any data longet than 64k will get truncated in this case too.. correct me if i am wrong,even if u set long to a very high value,data more than 64k in lenght will get truncated . sai --- Arup Nanda <[EMAIL PROTECTED]> wrote: > For situations li

Re: RMAN - Remote vs Local Backups

Metalink Note 73431.1 has an RMAN Compatibility Matrix. TargetRMANCatalog DBCatalog Schema 9.2.0>=9.0.3>=8.1.x >= RMAN executable An RMAN920 schema can be created in an Oracle 8.1.6 database that contains the recovery catalog for Oracle 9.2.0 databases. Have Fun :) DENNIS W

RE: HELP URGENT RMAN FAILS - FILE?????

Paula - I don't see where anyone replied, so . . . In Oracle 8i, backing up the control file with RMAN and then recovering that control file is a dicey business. I recall that part of the problem is the point in the backup the control file is backed, maybe not after the file backups. Anyway, I gav

RE: Oracle 9IAS

Ah! The old trick of the symjitc.dll. It's working now. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Estevez Sent: Saturday, May 31, 2003 3:20 PM To: Multiple recipients of list ORACLE-L Hi list, I'm trying to install 9IAS 1.0.2.2 in a W2000 SP3 but nothing co

Oracle 9IAS

Hi list, I'm trying to install 9IAS 1.0.2.2 in a W2000 SP3 but nothing comes up when clicking the setup button. Checked in metalink and nothing related to it. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon

RE: Parallel Query Server died

Funeral at 8pm EST, movie at 11pm EST on TNT ...   Raj -Original Message-From: Rajesh Dayal [mailto:[EMAIL PROTECTED]Sent: Saturday, May 31, 2003 2:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Parallel Query Server died After long time ..   LOL . 

RE: Tablespace management.

Then again, why query DBA_EXTENTS ? Pretty much anything that its got you can get from DBA_SEGMENTS, the exception being the file/block_id/blocks info. I would contend that the reason we want that level of information is when mapping segments to file position to determine I/O rates, which we can

FW: Tablespace management.

> -Original Message- > From: Niall Litchfield [mailto:[EMAIL PROTECTED] > Sent: 31 May 2003 14:42 > To: '[EMAIL PROTECTED]' > Subject: RE: Tablespace management. > > > Hi > > It might be a sobering exercise to work out how much the > "time and effort getting computing storage needs i

RE: Tablespace management.

This is not a comprehensive test by any means, though I think it should ally at least a few fears (and it gets me out of housework for half an hour or so. Comments with a SQL> select initial_EXTENT,next_EXTENT from dba_tablespaces 2 where tablespace_name='XXX'; INITIAL_EXTENT NEXT_EXT