RE: Partitioning
Thank you very much Conrad... -Original Message- Sent: Wednesday, February 26, 2003 5:31 PM To: Conrad Meertins; Multiple recipients of list ORACLE-L YES, here's an example: create table ate_headers(module_id varchar2(13), session_number varchar2(16), test_group number(4), test_date date, first_record char(1) default 'F', last_record char(1) default 'F', tester_id number(4), slot number(6), test_kind number(4), work_order varchar2(15), session_duration number, program_id number(4), spec_name varchar2(20), spec_revision varchar2(2), vector_name varchar2(12), vector_revision varchar2(2), bin_number number(6), constraint test_header_fk foreign key (module_id) references module_master(module_id) on delete cascade) partition by range (test_group) ( partition h1q398 values less than (2) tablespace ate1 storage(initial 150M next 150M maxextents 99), partition h2q398 values less than (3) tablespace ate2 storage(initial 150M next 150M maxextents 99), partition h3q398 values less than (4) tablespace ate3 storage(initial 150M next 150M maxextents 99), partition h4q398 values less than (5) tablespace ate4 storage(initial 150M next 150M maxextents 99), /* partition h5q398 values less than (6) tablespace ate5 storage(initial 150M next 150M maxextents 99), */ partition h6q398 values less than (100) tablespace ate6 storage(initial 150M next 150M maxextents 99)); Dick Goulet Reply Separator____ Author: "Conrad Meertins" <[EMAIL PROTECTED]> Date: 2/26/2003 1:44 PM If you have a table partitioned, can you specify the storage size of each partition in that tables I looked at dba_tab_partitions and dba_segments views. Although the show me storage information, I am unable to create a table where I can specify the storage size for each partition. Am I doing something wrong Or you cannot specify a storage size for partitions. Please help.. Thanks Conrad... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Conrad Meertins 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Conrad Meertins 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).
Partitioning
If you have a table partitioned, can you specify the storage size of each partition in that tables I looked at dba_tab_partitions and dba_segments views. Although the show me storage information, I am unable to create a table where I can specify the storage size for each partition. Am I doing something wrong Or you cannot specify a storage size for partitions. Please help.. Thanks Conrad... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Conrad Meertins 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).
Partitioning Storage Parameters
Team, Our tables are partitioned by 52 weeks. We would like to know the name of the partitions that are growing/increasing. Are there storage parameters for Partitions in Oracle 7, 8i, 9i ? Where can I find supporting documentation? Or. Where can I find excellent documentation about partition ? Thanks for you help Conrad... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Conrad Meertins 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: Oracle 7.3.4 Real-Time Re-indexing - Additional Information
ALTER ...REBUILD.. Thanks COnrad.. -Original Message- WILLIAMS Sent: Monday, January 13, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Conrad - What command did you use to re-index? Drop index / create index? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 13, 2003 8:44 AM To: Multiple recipients of list ORACLE-L Sorry, I forgot this additional infromation... Oracle created invalid objects when we ran rebuild. The odd thing was that the trace file showed an invalid object but the all_objects table showed a valid object. -Original Message- Sent: Monday, January 13, 2003 9:39 AM To: [EMAIL PROTECTED] Team, I have a Oracle 7.3.4 database on a AIX box that is in Archive Log Mode. While the users were on the system, we Re-Indexed our tables. Situation: The users complained, that they were unable to process their orders. Although, the log file showed that the re-indexing was successful, the users were still unable to process their orders. QUESTION: Are they any known issues/pit-falls when re-indexing real-time in version 7.x? Should you have the database in exclusive mode when re-indexing? Please assist. Thanks Conrad Meertins [EMAIL PROTECTED] DBA Masters -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Conrad Meertins 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Conrad Meertins 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).
Oracle 7.3.4 Real-Time Re-indexing
Team, I have a Oracle 7.3.4 database on a AIX box that is in Archive Log Mode. While the users were on the system, we Re-Indexed our tables. Situation: The users complained, that they were unable to process their orders. Although, the log file showed that the re-indexing was successful, the users were still unable to process their orders. QUESTION: Are they any known issues/pit-falls when re-indexing real-time in version 7.x? Should you have the database in exclusive mode when re-indexing? Please assist. Thanks Conrad Meertins [EMAIL PROTECTED] DBA Masters -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Conrad Meertins 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).
Oracle 7.3.4 Real-Time Re-indexing - Additional Information
Sorry, I forgot this additional infromation... Oracle created invalid objects when we ran rebuild. The odd thing was that the trace file showed an invalid object but the all_objects table showed a valid object. -Original Message- Sent: Monday, January 13, 2003 9:39 AM To: [EMAIL PROTECTED] Team, I have a Oracle 7.3.4 database on a AIX box that is in Archive Log Mode. While the users were on the system, we Re-Indexed our tables. Situation: The users complained, that they were unable to process their orders. Although, the log file showed that the re-indexing was successful, the users were still unable to process their orders. QUESTION: Are they any known issues/pit-falls when re-indexing real-time in version 7.x? Should you have the database in exclusive mode when re-indexing? Please assist. Thanks Conrad Meertins [EMAIL PROTECTED] DBA Masters -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Conrad Meertins 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).