Re: Select Query -- Return all rows of column as a single record ??

Thanx Rohit. Thanx everybody. for helping me to do this. On Wed, 12 Feb 2003 Negandhi, Hiten wrote : Is the number of rows in the test table fixed? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network

Select Query -- Return all rows of column as a single record ??

guys, SQL select A from test ; A --- 1 2 3 4 . . . 10 i need the result as A -- 1234...10 how to do this ? can someone help me ? the env. is oracle 8.1.6. TIA. Prem J. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: oraora oraora INET: [EMAIL PROTECTED

Re:

the information about 'statspack' ? or if it is a script would you please to share with me ? Thank you in advance for your help. Every comments and clues would be very appreciated. Rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: oraora oraora INET

Urgent - how to make SYSTEM tbls smaller ?

is cleared but the datafile does not get smaller. but how do i make the file smaller ? should i exp and imp the whole DB ? the ENV is 8.1.6/win2k . this is quite urgent.plz respond quickly. Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: oraora

Re: Queries Help

. Form a query to select the employees who have the salary more than their manager's salary. And if the mgr_id is null then that record should not be selected. Thanks and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: oraora oraora INET: [EMAIL

last used time of an index ??

guys, can i find out the time when an index was last used in Ver 8.1.6 ? Regards, Prem Khanna J. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

how to create datafile in shared network drive ??

ORACLE-L FAQ: http://www.orafaq.net -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

strange behaviour of sequence

); after some inserts .when he does SELECT from TESTTAB...he finds the values as : BREAD1 BREAD2 BREAD3 BREAD4 BREAD21 BREAD22 it should increment by 1.but it is not so ? any hint/clue Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: oraora

Re: Re: Strange behaviour of sequence

thanks a lot everybody. i have changed the sequence to NOCACHE. Regards, Prem Khanna J. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Unix for oracle dba -- Suggest a book ?

FAQ: http://www.orafaq.net -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

Re: AW: Unix for oracle dba -- Suggest a book ?

2001) Regards, Stefan -Ursprüngliche Nachricht- Von: oraora oraora [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 6. Januar 2003 11:14 An: Multiple recipients of list ORACLE-L Betreff: Unix for oracle dba -- Suggest a book ? Guys, i know a bit of Linux.and not completely a newbie

Re: RE: Unix for oracle dba -- Suggest a book ?

not a beginner's Unix book but it's accurate and detailed. regards, Mike Hately -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: Re: Migrate table data to CSV file - Urgent help !!!

Thanx Guys. I used a combination of repalce/translate to remove the unwanted characters.it worked out. thanx everybody. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Migrate table data to CSV file - Urgent help !!!

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: RE: export porblem ???

#17? Is the DB in archive log mode? Is the archiver getting stuck? - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Re: export porblem ???

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Re: export porblem ???

ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

export porblem ???

://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Re: RE: image storage confusion ?? -- UUDECODE

hth connor --- oraora oraora [EMAIL PROTECTED] wrote: Guys , i posted this already and this time my question is a bit different . I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system

Re: Re: Re: RE: image storage confusion ?? -- UUDECODE

NetApp on linux --- which will be better ? how do people usually handle data of such volume ? plz let me know how it is done normally. TIA. Jp. On Tue, 10 Dec 2002 chao_ping wrote : oraora oraora, For blob, it is ok, since it is all in the database, while for bfile, you

image storage confusion ??

with java . this being condition , i would like to know ur suggestion guys. my DB is oracle 8.1.6 on Win2k. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Best way to store images in DB ?

://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Best way to store images in DB ?

://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

9iR1 vs 9iR2 ?

Guys, which is the best..9i Release 1 or 9i Release 2 ? my company has decided to move to 9i. so cost does not matter. the environment is win2k. please let me know. TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat

Re: Re: 9iR1 vs 9iR2 ?

Thanx Joe. let me think about it. Jp. On Mon, 28 Oct 2002 Joe Testa wrote : based on metalink note, first level of support for 9ir1 ends 6/30/2003. you decide. joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City

Re: Location of Trace file

://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

role/priv. reqd to create/support a management server repository

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

ORA 604 followed by ORA 4031 error

: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself

how to change listener port ?

the steps involved ? TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

how to clone a DB ?

the disk layout is differnet , how should i rename the datafiles/log files/control files ? can someone throw light and explain me all the steps involved in detail ? Thanx in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL

RMAN backup to remote dir. - how ?

: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send

how to find no. of transactions/sec ?

Guys, my DB is on 8.1.6/Win2K. how do i find the number of transactions per second in my DB ? TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Oracle on windows vs Redhat

: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Standby with TAF config. - How to ?

Database - Concepts and Admin. manual. What i am not clear about is how to configure Standby DB with TAF so that least manual intervention is required ? Can anyone of u help me ? Any good resource for the same ? TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora

how to startup in restricted mode ?

if i am wrong . TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

ORA-12571 error while EXPORT

: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send

recursive calls for SELECT statement ???

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

[no subject]

roundtrips to/from client 2 sorts (memory) 0 sorts (disk) 1 rows processed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

explain plan - redo size ???

roundtrips to/from client 2 sorts (memory) 0 sorts (disk) 1 rows processed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

resizing/moving datafiles for performance ??

make any difference ? 10-20 MB of data gets added to the DB daily. if resizing/moving improves performance,what should be the size of my datafile ? kindly give me a solution guys. TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED

sequential reads/scattered reads

-- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

Re: RE: sequential reads/scattered reads

-- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

Re: Re: sequential reads/scattered reads

will be using the same r/w heads and you will not reduce I/O contention. oraora oraora To: Multiple recipients of list ORACLE-L oraoraora [EMAIL PROTECTED] @rediffmail.ccc

Buffer busy waits are 10.96% of non-idle waits

for you at Monsterindia.com. Go now http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public