Re: optimal set up of tablespaces on disks??
Thank you Jared!! Mine is OLTP, I need to more room for Data/indexes. I had that book, May be I need to refer again to understand more. Thanks again. From: Jared Still [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: optimal set up of tablespaces on disks?? Date: Fri, 28 Mar 2003 19:23:37 -0800 It depends: for maximum IO on redo, with mirrored redo logs: 4 2 x 36 RAID 1 for redo 1 2 x 36 for archive logs 1 2 x 36 for executables 2 8 x 36 RAID 10 for data/indexes ( about 250 gig usable ) If you choose not to let oracle mirror the redo logs, you could take four of those drives and add: 1 4 x 36 RAID 10. It really depends on your requirements. Do you need more room for data? Is this OLTP, DW, Hybrid? Anyway, this is a starting point. You would be wise to purchase and study 'Oracle Performance Tuning 101', available at an Amazon.com near you. Jared On Friday 28 March 2003 15:43, Peter R wrote: Hi Friends, Again I need help from you guys! I have 28 x 36.4Gb mirrored disks on AIX 5L, Would you guys suggest best way of arranging tablespaces across disks!! I have tablespaces like rbs,temp,tools,index,data etc. expecting with RAID 2 x 36.4 gb RAID-I 26 x 36.4 gb RAID -I + 0 Any ideas will greately appreciated. peter. _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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 this mailing list, send an E-Mail message to: [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). _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter R 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 this mailing list, send an E-Mail message to: [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).
optimal set up of tablespaces on disks??
Hi Friends, Again I need help from you guys! I have 28 x 36.4Gb mirrored disks on AIX 5L, Would you guys suggest best way of arranging tablespaces across disks!! I have tablespaces like rbs,temp,tools,index,data etc. expecting with RAID 2 x 36.4 gb RAID-I 26 x 36.4 gb RAID -I + 0 Any ideas will greately appreciated. peter. _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter R 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 this mailing list, send an E-Mail message to: [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).
big disks..OFA??
Hi Friends Now a days the disks are coming with 36/73Gb sizes for AIX, How can I make small filesystems to put data and indexes separately?? Although I have FastT700 controller, Is it okay putting all dbf files under one filesytem?? Does it affect performance, How about putting rbs/temp/redo?? Do I need to put under different filesystems?? Suppose I have two controller, How can I know, How many channels are there?? I have 25Gb table, what is the methodology for setting initial and next extents?? My DB is OLTP its conitousely growing on AIX 5L with Oracle 817. TIA peter. _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter R 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 this mailing list, send an E-Mail message to: [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).
migration
Hi Friends, Iam migrating data from 7.3.2 to 8.1.7.4 with exp/imp, when Iam importing into 8.1.7.4 Iam getting silly errors like IMP-00017: following statement failed with ORACLE error 1452: CREATE UNIQUE INDEX TTIITM009001$IDX1 ON TTIITM009001 I checked in metalink and other sites for help, I got sense that its all about NLS_LANG parameter!! But my both databases are US7ASCII character set!! I have no clue what to do?? I tried to set nls_lang and exported it!! But no use!! I got the sense its all about char set!! Any help will be appreciated!! TIA Peter. _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter R 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 this mailing list, send an E-Mail message to: [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).
Re: Best backup software for daily backups...
Thankyou Ruth, What about Veritas Netbackup and Tivoli software for bakcups, Which one do you think is best and effective in long term and easy to admin. Thanks again for your only response. From: Ruth Gramolini [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Best backup software for daily backups... Date: Wed, 29 Jan 2003 05:39:46 -0800 We are doing the same upgrade, and we will continue to use rman for all backups. Ruth - Original Message - From: Peter R To: Multiple recipients of list ORACLE-L Sent: Wednesday, January 29, 2003 7:39 AM Subject: Best backup software for daily backups... Hi Friends, We are going to upgrade our database(Oracle9i) with Unix server(AIX5.2), I would like to know best backup software for new production server with 250-350Gb database size. Ours is 24X7 shop, so we are going to take daily hotbackups. Any ideas and experiance from gurus!!! Thanks peter. _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter R 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 this mailing list, send an E-Mail message to: [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). _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter R 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 this mailing list, send an E-Mail message to: [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).
Best backup software for daily backups...
Hi Friends, We are going to upgrade our database(Oracle9i) with Unix server(AIX5.2), I would like to know best backup software for new production server with 250-350Gb database size. Ours is 24X7 shop, so we are going to take daily hotbackups. Any ideas and experiance from gurus!!! Thanks peter. _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter R 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 this mailing list, send an E-Mail message to: [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).
7.3.2 -7.3.4.4
Hi Friends, I had one of the oracle production database with 7.3.2 on AIX, I want to go 7.3.4 base first and apply patchset 7.3.4.4. Could any body have document that takes me step by step process!! The documentation is there in CDs, But not step by step process!! Thanks in advance peter. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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 this mailing list, send an E-Mail message to: [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).
Temp problem
Hi friends, My temp tablespace is showing full!! I try to wakeup smon thru oradebug wakeup 6; but getting error..I also used alter tablespace temp storage(pctincrease 0);..But it could't release space...any ideas to avoid bouncing the database??? tia peter. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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 an E-Mail message to: [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).
URGENT
Hi Friends, My all background processors accessing same file system, I did some reorg this weekend, But I shut down database like 4 times...all processors are waitingAny help will be highly appreicated!!! oracle@baan1 $ ps -ef|grep 14816 oracle 14816 1 2 13:59:00 - 0:49 ora_dbwr_baanIV oracle 80572 18974 2 14:27:27 pts/1 0:00 grep 14816 oracle@baan1 $ ps -ef|grep 15336 oracle 15336 1 0 13:59:00 - 0:12 ora_lgwr_baanIV oracle 83158 18974 2 14:27:55 pts/1 0:00 grep 15336 oracle@baan1 $ ps -ef|grep 17644 oracle 17644 1 0 13:59:00 - 0:16 ora_smon_baanIV oracle 85890 18974 2 14:28:21 pts/1 0:00 grep 17644 oracle@baan1 $ ps -ef|grep 18164 oracle 18164 1 0 13:59:00 - 0:03 ora_db01_baanIV oracle 84380 18974 1 14:28:44 pts/1 0:00 grep 18164 Thanks peter. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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 an E-Mail message to: [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).
Pls respond...: URGENT
Hi Friends, My all background processors accessing same file system, I did some reorg this weekend, But I shut down database like 4 times...all processors are waitingAny help will be highly appreicated!!! oracle@baan1 $ ps -ef|grep 14816 oracle 14816 1 2 13:59:00 - 0:49 ora_dbwr_baanIV oracle 80572 18974 2 14:27:27 pts/1 0:00 grep 14816 oracle@baan1 $ ps -ef|grep 15336 oracle 15336 1 0 13:59:00 - 0:12 ora_lgwr_baanIV oracle 83158 18974 2 14:27:55 pts/1 0:00 grep 15336 oracle@baan1 $ ps -ef|grep 17644 oracle 17644 1 0 13:59:00 - 0:16 ora_smon_baanIV oracle 85890 18974 2 14:28:21 pts/1 0:00 grep 17644 oracle@baan1 $ ps -ef|grep 18164 oracle 18164 1 0 13:59:00 - 0:03 ora_db01_baanIV oracle 84380 18974 1 14:28:44 pts/1 0:00 grep 18164 Thanks peter. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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 an E-Mail message to: [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).
Re: Pls respond...: URGENT
My one of disk showing full active...very hot!!! by bground processes accessing... hdisk51 88.7 926.6 139.3 2780 8 hdisk51 85.5 1217.0 176.2 3660 0 hdisk51 91.8 980.2 149.3 2948 From: Peter R [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Subject: Pls respond...: URGENT Date: Tue, 03 Sep 2002 19:32:14 + Hi Friends, My all background processors accessing same file system, I did some reorg this weekend, But I shut down database like 4 times...all processors are waitingAny help will be highly appreicated!!! oracle@baan1 $ ps -ef|grep 14816 oracle 14816 1 2 13:59:00 - 0:49 ora_dbwr_baanIV oracle 80572 18974 2 14:27:27 pts/1 0:00 grep 14816 oracle@baan1 $ ps -ef|grep 15336 oracle 15336 1 0 13:59:00 - 0:12 ora_lgwr_baanIV oracle 83158 18974 2 14:27:55 pts/1 0:00 grep 15336 oracle@baan1 $ ps -ef|grep 17644 oracle 17644 1 0 13:59:00 - 0:16 ora_smon_baanIV oracle 85890 18974 2 14:28:21 pts/1 0:00 grep 17644 oracle@baan1 $ ps -ef|grep 18164 oracle 18164 1 0 13:59:00 - 0:03 ora_db01_baanIV oracle 84380 18974 1 14:28:44 pts/1 0:00 grep 18164 Thanks peter. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Send and receive Hotmail on your mobile device: http://mobile.msn.com Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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 an E-Mail message to: [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).
Fwd: RE: Pls respond...: URGENT
My database okay, its slow, I can't do much work, too much waitingI want to bring as normal processing... From: Fink, Dan [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: Pls respond...: URGENT Date: Tue, 3 Sep 2002 13:58:02 -0600 Peter, What is the problem? What you are asking is not clear, which could be one reason you are not getting a response. Try restating the issue with exactly what the condition of the db is (up or down), what errors are being reported, etc. Dan Fink -Original Message- From: Peter R [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Subject: Pls respond...: URGENT Hi Friends, My all background processors accessing same file system, I did some reorg this weekend, But I shut down database like 4 times...all processors are waitingAny help will be highly appreicated!!! oracle@baan1 $ ps -ef|grep 14816 oracle 14816 1 2 13:59:00 - 0:49 ora_dbwr_baanIV oracle 80572 18974 2 14:27:27 pts/1 0:00 grep 14816 oracle@baan1 $ ps -ef|grep 15336 oracle 15336 1 0 13:59:00 - 0:12 ora_lgwr_baanIV oracle 83158 18974 2 14:27:55 pts/1 0:00 grep 15336 oracle@baan1 $ ps -ef|grep 17644 oracle 17644 1 0 13:59:00 - 0:16 ora_smon_baanIV oracle 85890 18974 2 14:28:21 pts/1 0:00 grep 17644 oracle@baan1 $ ps -ef|grep 18164 oracle 18164 1 0 13:59:00 - 0:03 ora_db01_baanIV oracle 84380 18974 1 14:28:44 pts/1 0:00 grep 18164 Thanks peter. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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 an E-Mail message to: [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). _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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 an E-Mail message to: [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).
unrecoverable..for creating Index
Hi Friends, Iam rebuilding my indexes! If I create my index as unrecoverable in Oracle 7.3 on AIX, its nologging(redo) only for creating index!! or is it applies entire life of that index!! I have strong feeling its only for creating index! It will log any inserts for table!!some one list member told that its not persistent!! The whole idea is making faster for creating index, at the same time I should be able to recover if any problem arises!! I don't know how it works?? Thanks peter. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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 an E-Mail message to: [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).
reorg steps..
Hi Gurus, Iam going to reorganize my bigtables, Could you people suggest any better ideas?? My environment is Oracle7.3.2 on AIX415. I want to minimize redo and undo at the time of reorg. If I create an Index in unrecoverable mode, Is it I have to bring in recoverable mode?? One of friend saying in the list its not persistent!! Steps for Reorg:- Create table COPY_Bigtable Tablespace sparedisk Storage(INITIAL 500M NEXT 300M PCTINCREASE 0) Unrecoverable Parallel(DEGREE 4) AS Select * from Bigtable; Drop table Bigtable, Coalesce the entire TABLESPACE !! Create Bigtable thru scripts with suitable storage parameters Insert /*+ append */ into Bigtable SELECT * FROM COPY_Bigtable; Rebuild the Indexes with unrecoverable option. Any better ideas?? TIA peter. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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 an E-Mail message to: [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).
Simple question on logging..
Hi Gurus, How can I turn off logging for a table in Oracle7.3 database. Iam planning to reorg thru ctas and want to use append hint for loading data. SQL alter table tt unrecoverable; alter table tt unrecoverable * ERROR at line 1: ORA-01735: invalid ALTER TABLE option SQL alter table tt nologging; alter table tt nologging * ERROR at line 1: ORA-01735: invalid ALTER TABLE option TIA peter. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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 an E-Mail message to: [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).
RE: Transferring data from one table to another
Iam planning to copy 18-40Million rows thru CTAS!! My question is which one is efficient, CTAS or using cursor in pl/sql Procedure!! thanks peter. From: Abdul Aleem [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Transferring data from one table to another Date: Sun, 11 Aug 2002 23:23:19 -0800 Thank you, Amjad, The problem is that then I have to write a procedure for each of the tables. I was looking for something that could be set at database level and would apply to every table. Aleem -Original Message- Sent: Monday, August 12, 2002 10:43 AM To:Multiple recipients of list ORACLE-L Subject: RE: Transferring data from one table to another well if u wanna commit after 1000 records u could very well use a cursor and within the loop keep a counter which will indicate the no. of records inserted...upon reaching 1000 records just commit and reinitialize the counter.. i have written the Pseudo code below: declare cursor c1 is SELECT * from schema2.abc; cntr number := 0; begin for c1_abc in c1 loop insert into schema1.abc values contained in c1_abc; cntr := cntr +1; if (cntr = 1000)then cntr := 0; commit; end if; end loop; /* the following commit is 4 last set of records that might not b commited*/ commit; end; rgds, Ams. www.medicomsoft.com -Original Message- Sent: Monday, August 12, 2002 8:23 AM To: Multiple recipients of list ORACLE-L Hi, We are transferring data from one table in a schema to another table in another schema with identical fields using INSERT INTO schema1.abc (SELECT * from schema2.abc) The source table has 1.6 million records. The tablespace increases to consume full disk space and yet seems to be demanding more so the operation doesn't complete. Is there a possibility to process commit after every 1,000 records? Is there any other way of doing it? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem 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 an E-Mail message to: [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 ORACLE-L FAQ: http://www.orafaq.com -- Author: Amjad Saiyed 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 an E-Mail message to: [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 ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem 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 an E-Mail message to: [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). _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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 an E-Mail message to: [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).
reorg and rebuild
Hi Friends, Iam reorganizing my tables thru copy(CTAS), So when Iam re-inserting data into my Original table Will the indexes will build automatically or I have to rebuild?? Here Iam not doing for indexes anything i.e Iam not disabling it. I want to create table thru CTAS, truncate original table, copy back data into original table from duplicate table. So that I can pack data and get back my space back. My environment is v7.3 on AIX. Thanks in advance peter. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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 an E-Mail message to: [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).
RE: reorg and rebuild
Dennis, This is ERP application, So I don't want to touch any structures!!But I want my space back from last 3 heavy purges and want to improve response time by repacking the data. By truncating my highwatermark will come down from 25Gb size to half!! and it had 3 indexes size 15G. Date: Wed, 24 Jul 2002 11:29:45 -0800 Peter If you don't do anything to the indexes, like drop them, they will be there when you load the data back. Of course, if your table is really large, then the load time will be longer. You may also want to investigate ALTER TABLE MOVE. Now that command will require you to rebuild the indexes. What are you trying to accomplish by moving, truncating, moving the data back? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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 an E-Mail message to: [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).
[no subject]
Hi Guys, I need to put one hour back for my OS(aix) So How will my database(7.3) handle this?? What steps I have to take?? Any light regarding that?? Thanks in advance peter. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R 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 an E-Mail message to: [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).