RE: IMP-00003: ORACLE error 1659 encountered
- From: "Don Granaman" <DonGranaman@xxxxxxxxxxxxxxx>
- To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, <oracle-l-bounce@xxxxxxxxxxxxx>
- Date: Wed, 15 Apr 2009 14:24:26 -0500
... with ignore=Y on the import.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
TESTAJ3@xxxxxxxxxxxxxx
Sent: Tuesday, April 14, 2009 5:29 PM
To: Roger.Xu@xxxxxxxx
Cc: oracle-l-freelists; oracle-l-bounce@xxxxxxxxxxxxx
Subject: Re: IMP-00003: ORACLE error 1659 encountered
if the export was done compress=y then pre-create the table and redo the
import for that one table.
joe
_______________________________________
Joe Testa, Oracle Certified Professional
Senior Consultant
Data Engineering and Administration
Nationwide Investments
(Work) 614-677-1668
(Cell) 614-312-6715
Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.
From:
"Xu, Roger" <Roger.Xu@xxxxxxxx>
To:
"oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>
Date:
04/14/2009 06:27 PM
Subject:
IMP-00003: ORACLE error 1659 encountered
Sent by:
oracle-l-bounce@xxxxxxxxxxxxx
________________________________
Hi List,
Our DBA is encountering the following problem and I think it's because
the initial extent size is greater than the tablespace free space. The
question is: How to modify the initial extent while importing?
Oracle10gR2
IMP-00017: following statement failed with ORACLE error 1659:
"CREATE TABLE "C_RESULT" (...) PCTFREE 10 PCTUSED 40
INITRANS 1 MAXTRANS 255
STORAGE
(INITIAL 2079326208 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "ARCHIVED" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1659 encountered
ORA-01659: unable to allocate MINEXTENTS beyond 29 in tablespace
ARCHIVED
Thanks,
Roger
http://www.drpeppersnapplegroup.com/about/corporate
<http://www.drpeppersnapplegroup.com/about/corporate> to learn more
about Dr Pepper Snapple Group's commitment to corporate social
responsibility.
Please be conscious of the environment and print this email only if
absolutely necessary.
This e-mail (including any attachments) is confidential and may contain
privileged information of Dr Pepper Snapple Group, Inc. and/or its
subsidiaries ("Dr Pepper Snapple Group"). If you are not the intended
recipient or receive it in error, you may not use, distribute, disclose
or copy any of the information contained within it and it may be
unlawful to do so. If you are not the intended recipient, please notify
us immediately by returning this e-mail to us at
mailto:mailerror@xxxxxxxx <mailto:mailerror@xxxxxxxx> and destroy all
copies. Any views expressed by individuals within this e-mail do not
necessarily reflect the views of Dr Pepper Snapple Group. This e-mail
does not constitute a binding offer, acceptance, amendment, waiver or
other agreement, unless the intent that an e-mail will constitute such
is clearly stated in the body of the email. Recipients are advised to
subject this e-mail and attachments to their own virus checking, in
keeping with good computing practice. Please note that e-mail r
eceived by Dr Pepper Snapple Group may be monitored in accordance with
applicable law.
--
//www.freelists.org/webpage/oracle-l
<//www.freelists.org/webpage/oracle-l>
Other related posts:
