Re: exp73 dumpparam for unlimited extents?
Thanks everyone for your advice. If I want to retrofit to 7.3.4 I have to create the tables sans storage clause then import import the data . Otherwise wait until the database upgrade. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical 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: exp73 dumpparam for unlimited extents?
LMTs came with 8i (8.1.5 afaik) - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 3:18 PM > I don't believe LMTs are supported in 7.3.x... > > > --- Don Granaman <[EMAIL PROTECTED]> wrote: > > With compress=N, you will get essentially the same mish-mash of > > extents you > > had previously - unless you are importing into a LMT. > > > > You have basically two options: > > > > 1) Pre-create the objects with a storage clause specifying the extent > > sizes > > you want - with initial and next the same size. Then import with > > ignore=Y. > > Of course, if you drop the users, you will have to recreate them > > before > > pre-creating the objects. This is the only option for > > dictionary-managed > > tablespaces to get uniform extents. (Hint: imp ... > > indexfile=somefilename.sql ..., edit somefilename.sql to (1) > > uncomment the > > create table statements and (2) modify storage clauses, then run > > somefilename.sql. If the export is large, you may wish to split this > > into > > two parts - one for the tables and one for the indexes and > > constraints. (It > > is a little more complicated than it might seem at first, but isn't > > too bad. > > One possible approach is to perform one export with rows=Y indexes=N > > constraints=N and another with rows=N indexes=Y constraints=Y. > > Details left > > as an exercise for the reader ;-) > > > > 2) Convert the tablespace(s) to LMT(s) with uniform extents - or drop > > and > > recreate them as such - prior to the import. > > > > In the vast majority of cases, (2) is preferred. > > > > Don Granaman > > [certifiable OraSaurus] > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Saturday, June 29, 2002 11:53 PM > > > > > > Hello, > > > > Running Oracle 7.3.4.4 on Win2k. > > Trying to implement unlimited extents of the same size. (Same size > > works > > for us). > > Set the tablespace defaults > > Dumped the users > > Dropped the users > > Imported the users > > > > Tables still had the same mish-mash of extents and max extents 121 > > > > Here are my dump params > > USERID = system/@** > > FILE = c:\dumps\test.dmp > > LOG = c:\dumps\test.log > > FULL = Y > > buffer=100 > > consistent=y > > compress=n > > > > That did not work so I tried dumping an individual user > > USERID = system/*@*** > > FILE = c:\dumps\test.dmp > > LOG = c:\dumps\test.log > > FULL = N > > COMPRESS = N > > owner=restek > > > > Still get mish-mash extents on import. > > > > The load was always: > > USERID = system/**@* > > FILE = c:\dumps\test.dmp > > LOG = c:\dumps\test.dmprs.implog > > FROMUSER = restek > > TOUSER = restek > > > > My quick test of create table tmp_xyz as select * from xyz gives me > > the > > result I want. > > > > Any suggestions? Do I have to wait until I upgrade to 8i or 9i? > > > > TIA > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Robert Monical > > 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: Don Granaman > > 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). > > > __ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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 PR
Re: exp73 dumpparam for unlimited extents?
I don't believe LMTs are supported in 7.3.x... --- Don Granaman <[EMAIL PROTECTED]> wrote: > With compress=N, you will get essentially the same mish-mash of > extents you > had previously - unless you are importing into a LMT. > > You have basically two options: > > 1) Pre-create the objects with a storage clause specifying the extent > sizes > you want - with initial and next the same size. Then import with > ignore=Y. > Of course, if you drop the users, you will have to recreate them > before > pre-creating the objects. This is the only option for > dictionary-managed > tablespaces to get uniform extents. (Hint: imp ... > indexfile=somefilename.sql ..., edit somefilename.sql to (1) > uncomment the > create table statements and (2) modify storage clauses, then run > somefilename.sql. If the export is large, you may wish to split this > into > two parts - one for the tables and one for the indexes and > constraints. (It > is a little more complicated than it might seem at first, but isn't > too bad. > One possible approach is to perform one export with rows=Y indexes=N > constraints=N and another with rows=N indexes=Y constraints=Y. > Details left > as an exercise for the reader ;-) > > 2) Convert the tablespace(s) to LMT(s) with uniform extents - or drop > and > recreate them as such - prior to the import. > > In the vast majority of cases, (2) is preferred. > > Don Granaman > [certifiable OraSaurus] > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Saturday, June 29, 2002 11:53 PM > > > Hello, > > Running Oracle 7.3.4.4 on Win2k. > Trying to implement unlimited extents of the same size. (Same size > works > for us). > Set the tablespace defaults > Dumped the users > Dropped the users > Imported the users > > Tables still had the same mish-mash of extents and max extents 121 > > Here are my dump params > USERID = system/@** > FILE = c:\dumps\test.dmp > LOG = c:\dumps\test.log > FULL = Y > buffer=100 > consistent=y > compress=n > > That did not work so I tried dumping an individual user > USERID = system/*@*** > FILE = c:\dumps\test.dmp > LOG = c:\dumps\test.log > FULL = N > COMPRESS = N > owner=restek > > Still get mish-mash extents on import. > > The load was always: > USERID = system/**@* > FILE = c:\dumps\test.dmp > LOG = c:\dumps\test.dmprs.implog > FROMUSER = restek > TOUSER = restek > > My quick test of create table tmp_xyz as select * from xyz gives me > the > result I want. > > Any suggestions? Do I have to wait until I upgrade to 8i or 9i? > > TIA > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Robert Monical > 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: Don Granaman > 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). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: exp73 dumpparam for unlimited extents?
Absolutely! I should have read more closely! Don Granaman [Orasaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 1:41 AM For the reported problem, (1) is the only option as (2) is not possible with 7.3.x database. - Kirti -Original Message- Sent: Sunday, June 30, 2002 9:28 PM To: Multiple recipients of list ORACLE-L With compress=N, you will get essentially the same mish-mash of extents you had previously - unless you are importing into a LMT. You have basically two options: 1) Pre-create the objects with a storage clause specifying the extent sizes you want - with initial and next the same size. Then import with ignore=Y. Of course, if you drop the users, you will have to recreate them before pre-creating the objects. This is the only option for dictionary-managed tablespaces to get uniform extents. (Hint: imp ... indexfile=somefilename.sql ..., edit somefilename.sql to (1) uncomment the create table statements and (2) modify storage clauses, then run somefilename.sql. If the export is large, you may wish to split this into two parts - one for the tables and one for the indexes and constraints. (It is a little more complicated than it might seem at first, but isn't too bad. One possible approach is to perform one export with rows=Y indexes=N constraints=N and another with rows=N indexes=Y constraints=Y. Details left as an exercise for the reader ;-) 2) Convert the tablespace(s) to LMT(s) with uniform extents - or drop and recreate them as such - prior to the import. In the vast majority of cases, (2) is preferred. Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, June 29, 2002 11:53 PM Hello, Running Oracle 7.3.4.4 on Win2k. Trying to implement unlimited extents of the same size. (Same size works for us). Set the tablespace defaults Dumped the users Dropped the users Imported the users Tables still had the same mish-mash of extents and max extents 121 Here are my dump params USERID = system/@** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = Y buffer=100 consistent=y compress=n That did not work so I tried dumping an individual user USERID = system/*@*** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = N COMPRESS = N owner=restek Still get mish-mash extents on import. The load was always: USERID = system/**@* FILE = c:\dumps\test.dmp LOG = c:\dumps\test.dmprs.implog FROMUSER = restek TOUSER = restek My quick test of create table tmp_xyz as select * from xyz gives me the result I want. Any suggestions? Do I have to wait until I upgrade to 8i or 9i? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical 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: Don Granaman 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: Deshpande, Kirti 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: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --
Re: exp73 dumpparam for unlimited extents?
Don Granaman wrote: > > With compress=N, you will get essentially the same mish-mash of extents you > had previously - Hmmm, that's hair-splitting, but if you reimport into a tablespace from which all objects have been dropped and that you have coalesced, you will have the same number of extents but they will all be created one after the other - as many 'logical' extents as before, but as far as the 'macroscopic' (i.e. let's forget about how the OS deals with its blocks and what happens on the disk) physical level is concerned there will hardly be any difference with compress=Y immediately after creation. That said, nobody cares much about external fragmentation anyway ... -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: RE: exp73 dumpparam for unlimited extents?
And how will it be of help in this export/import issue ? Sorry, I did not follow what you mentioned. - Kirti -Original Message- Sent: Sunday, June 30, 2002 10:48 PM To: Multiple recipients of list ORACLE-L Deshpande, Kirti£¬ hi, check oracle undocumented parameter: _system_trigger_enabled=false. If this is set, then all database event trigger will be disabled. Good luck Good luck! chaos [EMAIL PROTECTED] zhu chao DBA of Eachnet.com 86-021-32174588-667 ÔÚ 2002-06-30 11:58:00 You wrote: >No, you do not have to wait for 8i or 9i >You are almost there to get what you want. >What you need to do prior to import is build all the tables without any >storage cluase in the CREATE TABLLE|INDEX syntax. It will default to the >tablespace settings. And them import with IGNORE=Y option (since tables are >already there). By default, Oracle will use the storage clause from the >import file. You can not tell Oracle to not have it created while exporting. >Pre-building the tables is the only choice. > >In your quick test, you did not specify the storage clause, so it worked! > >You can use the indexfile= option of the import utility, to build >a script to create tables, indexes. Edit the script for storage clauses >(i.e. remove them), and build the tables first. > > >HTH, > >- Kirti > >-Original Message- >Sent: Saturday, June 29, 2002 11:53 PM >To: Multiple recipients of list ORACLE-L > > >Hello, > >Running Oracle 7.3.4.4 on Win2k. >Trying to implement unlimited extents of the same size. (Same size works >for us). >Set the tablespace defaults >Dumped the users >Dropped the users >Imported the users > >Tables still had the same mish-mash of extents and max extents 121 > >Here are my dump params >USERID = system/@** >FILE = c:\dumps\test.dmp >LOG = c:\dumps\test.log >FULL = Y >buffer=100 >consistent=y >compress=n > >That did not work so I tried dumping an individual user >USERID = system/*@*** >FILE = c:\dumps\test.dmp >LOG = c:\dumps\test.log >FULL = N >COMPRESS = N >owner=restek > >Still get mish-mash extents on import. > >The load was always: >USERID = system/**@* >FILE = c:\dumps\test.dmp >LOG = c:\dumps\test.dmprs.implog >FROMUSER = restek >TOUSER = restek > >My quick test of create table tmp_xyz as select * from xyz gives me the >result I want. > >Any suggestions? Do I have to wait until I upgrade to 8i or 9i? > >TIA > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: exp73 dumpparam for unlimited extents?
For the reported problem, (1) is the only option as (2) is not possible with 7.3.x database. - Kirti -Original Message- Sent: Sunday, June 30, 2002 9:28 PM To: Multiple recipients of list ORACLE-L With compress=N, you will get essentially the same mish-mash of extents you had previously - unless you are importing into a LMT. You have basically two options: 1) Pre-create the objects with a storage clause specifying the extent sizes you want - with initial and next the same size. Then import with ignore=Y. Of course, if you drop the users, you will have to recreate them before pre-creating the objects. This is the only option for dictionary-managed tablespaces to get uniform extents. (Hint: imp ... indexfile=somefilename.sql ..., edit somefilename.sql to (1) uncomment the create table statements and (2) modify storage clauses, then run somefilename.sql. If the export is large, you may wish to split this into two parts - one for the tables and one for the indexes and constraints. (It is a little more complicated than it might seem at first, but isn't too bad. One possible approach is to perform one export with rows=Y indexes=N constraints=N and another with rows=N indexes=Y constraints=Y. Details left as an exercise for the reader ;-) 2) Convert the tablespace(s) to LMT(s) with uniform extents - or drop and recreate them as such - prior to the import. In the vast majority of cases, (2) is preferred. Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, June 29, 2002 11:53 PM Hello, Running Oracle 7.3.4.4 on Win2k. Trying to implement unlimited extents of the same size. (Same size works for us). Set the tablespace defaults Dumped the users Dropped the users Imported the users Tables still had the same mish-mash of extents and max extents 121 Here are my dump params USERID = system/@** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = Y buffer=100 consistent=y compress=n That did not work so I tried dumping an individual user USERID = system/*@*** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = N COMPRESS = N owner=restek Still get mish-mash extents on import. The load was always: USERID = system/**@* FILE = c:\dumps\test.dmp LOG = c:\dumps\test.dmprs.implog FROMUSER = restek TOUSER = restek My quick test of create table tmp_xyz as select * from xyz gives me the result I want. Any suggestions? Do I have to wait until I upgrade to 8i or 9i? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical 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: Don Granaman 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: Deshpande, Kirti 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: RE: exp73 dumpparam for unlimited extents?
Deshpande, Kirti£¬ hi, check oracle undocumented parameter: _system_trigger_enabled=false. If this is set, then all database event trigger will be disabled. Good luck Good luck! chaos [EMAIL PROTECTED] zhu chao DBA of Eachnet.com 86-021-32174588-667 ÔÚ 2002-06-30 11:58:00 You wrote: >No, you do not have to wait for 8i or 9i >You are almost there to get what you want. >What you need to do prior to import is build all the tables without any >storage cluase in the CREATE TABLLE|INDEX syntax. It will default to the >tablespace settings. And them import with IGNORE=Y option (since tables are >already there). By default, Oracle will use the storage clause from the >import file. You can not tell Oracle to not have it created while exporting. >Pre-building the tables is the only choice. > >In your quick test, you did not specify the storage clause, so it worked! > >You can use the indexfile= option of the import utility, to build >a script to create tables, indexes. Edit the script for storage clauses >(i.e. remove them), and build the tables first. > > >HTH, > >- Kirti > >-Original Message- >Sent: Saturday, June 29, 2002 11:53 PM >To: Multiple recipients of list ORACLE-L > > >Hello, > >Running Oracle 7.3.4.4 on Win2k. >Trying to implement unlimited extents of the same size. (Same size works >for us). >Set the tablespace defaults >Dumped the users >Dropped the users >Imported the users > >Tables still had the same mish-mash of extents and max extents 121 > >Here are my dump params >USERID = system/@** >FILE = c:\dumps\test.dmp >LOG = c:\dumps\test.log >FULL = Y >buffer=100 >consistent=y >compress=n > >That did not work so I tried dumping an individual user >USERID = system/*@*** >FILE = c:\dumps\test.dmp >LOG = c:\dumps\test.log >FULL = N >COMPRESS = N >owner=restek > >Still get mish-mash extents on import. > >The load was always: >USERID = system/**@* >FILE = c:\dumps\test.dmp >LOG = c:\dumps\test.dmprs.implog >FROMUSER = restek >TOUSER = restek > >My quick test of create table tmp_xyz as select * from xyz gives me the >result I want. > >Any suggestions? Do I have to wait until I upgrade to 8i or 9i? > >TIA > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Robert Monical > INET: [EMAIL PROTECTED] >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Deshpande, Kirti > 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: chaos 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: exp73 dumpparam for unlimited extents?
With compress=N, you will get essentially the same mish-mash of extents you had previously - unless you are importing into a LMT. You have basically two options: 1) Pre-create the objects with a storage clause specifying the extent sizes you want - with initial and next the same size. Then import with ignore=Y. Of course, if you drop the users, you will have to recreate them before pre-creating the objects. This is the only option for dictionary-managed tablespaces to get uniform extents. (Hint: imp ... indexfile=somefilename.sql ..., edit somefilename.sql to (1) uncomment the create table statements and (2) modify storage clauses, then run somefilename.sql. If the export is large, you may wish to split this into two parts - one for the tables and one for the indexes and constraints. (It is a little more complicated than it might seem at first, but isn't too bad. One possible approach is to perform one export with rows=Y indexes=N constraints=N and another with rows=N indexes=Y constraints=Y. Details left as an exercise for the reader ;-) 2) Convert the tablespace(s) to LMT(s) with uniform extents - or drop and recreate them as such - prior to the import. In the vast majority of cases, (2) is preferred. Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, June 29, 2002 11:53 PM Hello, Running Oracle 7.3.4.4 on Win2k. Trying to implement unlimited extents of the same size. (Same size works for us). Set the tablespace defaults Dumped the users Dropped the users Imported the users Tables still had the same mish-mash of extents and max extents 121 Here are my dump params USERID = system/@** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = Y buffer=100 consistent=y compress=n That did not work so I tried dumping an individual user USERID = system/*@*** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = N COMPRESS = N owner=restek Still get mish-mash extents on import. The load was always: USERID = system/**@* FILE = c:\dumps\test.dmp LOG = c:\dumps\test.dmprs.implog FROMUSER = restek TOUSER = restek My quick test of create table tmp_xyz as select * from xyz gives me the result I want. Any suggestions? Do I have to wait until I upgrade to 8i or 9i? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical 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: Don Granaman 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: exp73 dumpparam for unlimited extents?
No, you do not have to wait for 8i or 9i You are almost there to get what you want. What you need to do prior to import is build all the tables without any storage cluase in the CREATE TABLLE|INDEX syntax. It will default to the tablespace settings. And them import with IGNORE=Y option (since tables are already there). By default, Oracle will use the storage clause from the import file. You can not tell Oracle to not have it created while exporting. Pre-building the tables is the only choice. In your quick test, you did not specify the storage clause, so it worked! You can use the indexfile= option of the import utility, to build a script to create tables, indexes. Edit the script for storage clauses (i.e. remove them), and build the tables first. HTH, - Kirti -Original Message- Sent: Saturday, June 29, 2002 11:53 PM To: Multiple recipients of list ORACLE-L Hello, Running Oracle 7.3.4.4 on Win2k. Trying to implement unlimited extents of the same size. (Same size works for us). Set the tablespace defaults Dumped the users Dropped the users Imported the users Tables still had the same mish-mash of extents and max extents 121 Here are my dump params USERID = system/@** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = Y buffer=100 consistent=y compress=n That did not work so I tried dumping an individual user USERID = system/*@*** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = N COMPRESS = N owner=restek Still get mish-mash extents on import. The load was always: USERID = system/**@* FILE = c:\dumps\test.dmp LOG = c:\dumps\test.dmprs.implog FROMUSER = restek TOUSER = restek My quick test of create table tmp_xyz as select * from xyz gives me the result I want. Any suggestions? Do I have to wait until I upgrade to 8i or 9i? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
exp73 dumpparam for unlimited extents?
Hello, Running Oracle 7.3.4.4 on Win2k. Trying to implement unlimited extents of the same size. (Same size works for us). Set the tablespace defaults Dumped the users Dropped the users Imported the users Tables still had the same mish-mash of extents and max extents 121 Here are my dump params USERID = system/@** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = Y buffer=100 consistent=y compress=n That did not work so I tried dumping an individual user USERID = system/*@*** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = N COMPRESS = N owner=restek Still get mish-mash extents on import. The load was always: USERID = system/**@* FILE = c:\dumps\test.dmp LOG = c:\dumps\test.dmprs.implog FROMUSER = restek TOUSER = restek My quick test of create table tmp_xyz as select * from xyz gives me the result I want. Any suggestions? Do I have to wait until I upgrade to 8i or 9i? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical 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).