Re: Are RAID 1+0 and 10 the same thing?

2001-09-20 Thread Deepender Kr Gupta
There is no diff between RAID 10 and 1+0. but 10 and 01 are different. out of which 10 is better than 01.. --deepender - Original Message - Date: Thursday, September 20, 2001 5:05 pm > Hi List, > > is there any difference between 1+0 and 10? > > Regards, > Ed > -- > Please see the of

Re: Sqlplus tunning

2001-09-18 Thread Deepender Kr Gupta
try nested query in place of sort join method... - Original Message - Date: Wednesday, September 19, 2001 11:10 am > Try to use Index for big table ITEM > To avoid full table scan. > > Create index item_index on item(no); > > This will speed the process... > > --- Sinardy <[EMAIL PROT

RE: Dump Oracle Tables To ASCII/Comma Delimited File ..Summary

2001-09-18 Thread Deepender Kr Gupta
Hi All, Here is the summary of all the mails I have recieved to Convert an oracle table into ASCII/Comma delimeted file. 1. Using sqlplus Set head off set pages 1000 spool result.lis Select col1 ||','|| col2 ||','|| col3 from table; spool off or 2. Set colsep , spool r

Dump Oracle Tables To ASCII/Comma Delimited File

2001-09-13 Thread Deepender Kr Gupta
Hi everybody, Can anybody tell me the command/tool in oracle that can dump Oracle Tables To ASCII/Comma Delimited File. Regds deepender gupta -- Information transmitted by this

Migration from Informix to oracle

2001-09-11 Thread Deepender Kr Gupta
Hi All, Can anybody suggest me the steps to migrate to oracle database from Informix ? Can it be done simply by using sqlloader oracle utility ? Kindly reply. Regards, Deepender ---

Re: RE: Alter tablespace add datafile

2001-09-06 Thread Deepender Kr Gupta
yes I am also getting a lot of mails from himmseems that he does not have any work.. - Original Message - Date: Thursday, September 6, 2001 6:05 pm > You are not the only one. I was wondering who is this guy > and out of nowhere he is answering all the questions (I didn't > read t

DB link for nonoracle databases

2001-05-01 Thread Deepender Kr Gupta
SQL server . Both are on NT. Thanks in Advance. Deepender -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepender Kr Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Inter

RE: MTS&Cost based Optimzer

2001-04-24 Thread Deepender Kr Gupta
o: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official

RE: Unable to open the database,Urgent!!!

2001-04-04 Thread Deepender Kr Gupta
me of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepender Kr Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 F