Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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=<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,
-----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: tech_at_restek.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.com
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: ListGuru_at_fatcity.com (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). Received on Sun Jun 30 2002 - 14:58:19 CDT