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=<filename> 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=1000000 >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).