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

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 into an

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

RE: Parallel Query Server died

Funeral at 8pm EST, movieat11pm 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 .

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: 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

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

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

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 like

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

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

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: 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 you

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: 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

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, movieat11pm EST on TNT ... Raj -Original

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

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

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.

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 one

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

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.

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) .

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