OraFAQ Forum: Backup & Recovery » tablespace problem while import

Home » RDBMS Server » Backup & Recovery » tablespace problem while import (9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

tablespace problem while import [message #602959]

Tue, 10 December 2013 10:06

emadnabil
Messages: 179
Registered: August 2007

Senior Member

Dear all
we have a problem related to table space

suppose this problem
1. we have a user called "clinic_2013" located on table space "clinic_2013" from database 10g "orcl1"
2. we took an export of the user "clinic_2013"
3. created a new user "clinic_2014" with new default tablespace "clinic_2014" on datase 9i "orcl2" (this database contains also "clinic_2013" tablespace
4. imported that dump (no. 2)
5. when see the log file we got errors of

ORA-01659: unable to allocate MINEXTENTS beyond 8 in tablespace CLINIC_2013

we tried to get the tablespace "clinic_2013" offline and then tried to import again
we got the same error

so how to solve this issue

the syntax of creating the user is

create user CLINIC_2014
  identified by CLINIC_2014
   default tablespace CLINIC_2014
  temporary tablespace TEMP
  profile DEFAULT;
-- Grant/Revoke role privileges 
grant connect to CLINIC_2014;
grant dba to CLINIC_2014;
grant resource to CLINIC_2014;
-- Grant/Revoke system privileges 
grant unlimited tablespace to CLINIC_2014;

the syntax of export

exp CLINIC_2013/CLINIC_2013@ORCL1 file=d:\clinic_2014.dmp log=d:\clinic_2014.log statistics=none compress=Y

the syntax of import

imp CLINIC_2014/CLINIC_2014@orcl file=d:\clinic_2014.dmp log=d:\clinic_2014_IMP.log full=yes

thanks

Report message to a moderator

Re: tablespace problem while import [message #602963 is a reply to message #602959]

Tue, 10 December 2013 10:14

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please export with compress=n and try again.

Report message to a moderator

Re: tablespace problem while import [message #602964 is a reply to message #602959]

Tue, 10 December 2013 10:21

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

You are importing the objects into the clinic_2013 schema and into the clinic_2013 tablespace. Is that what you want to do?

Report message to a moderator

Re: tablespace problem while import [message #602965 is a reply to message #602963]

Tue, 10 December 2013 10:21

emadnabil
Messages: 179
Registered: August 2007

Senior Member

Please export with compress=n and try again.

Thanks for reply
tested and didnot work
i got error

ORA-01658: unable to create INITIAL extent for segment in tablespace CLINIC_2013

Report message to a moderator

Re: tablespace problem while import [message #602968 is a reply to message #602965]

Tue, 10 December 2013 10:24

emadnabil
Messages: 179
Registered: August 2007

Senior Member

Quote:

You are importing the objects into the clinic_2013 schema and into the clinic_2013 tablespace. Is that what you want to do?

Thanks for reply
no "clinic_2013" is the old user that I have exported
I want to import this dump to the new user "clinic_2014" with default tablespace "2014"

Report message to a moderator

Re: tablespace problem while import [message #602970 is a reply to message #602968]

Tue, 10 December 2013 10:34

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Add a fromuser/touser clause?
And make sure you have the CLINIC_2014 to be sufficient enough to hold the data.

[Updated on: Tue, 10 December 2013 10:38]

Report message to a moderator

Re: tablespace problem while import [message #602971 is a reply to message #602970]

Tue, 10 December 2013 10:38

emadnabil
Messages: 179
Registered: August 2007

Senior Member

Quote:

Add a fromuser/touser clause?

tested and didnot work

Report message to a moderator

Re: tablespace problem while import [message #602972 is a reply to message #602971]

Tue, 10 December 2013 10:41

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

remove the resource role,
create clinic_2014 tablespace with adequate space/settings.

It should alteast talk to 2014 tablespace.

Report message to a moderator

Re: tablespace problem while import [message #602973 is a reply to message #602972]

Tue, 10 December 2013 10:51

emadnabil
Messages: 179
Registered: August 2007

Senior Member

Quote:

remove the resource role,
create clinic_2014 tablespace with adequate space/settings.

It should alteast talk to 2014 tablespace.

so i created the user in this way

-- Create the user 
create user CLINIC_2014
  identified by CLINIC_2014
   default tablespace CLINIC_2014
  temporary tablespace TEMP
  profile DEFAULT;
grant connect to CLINIC_2014;
grant dba to CLINIC_2014;
--grant resource to CLINIC_2014;
-- Grant/Revoke system privileges 
grant unlimited tablespace to CLINIC_2014;

alter user CLINIC_2014 quota 100m on CLINIC_2014;

while import
i got the same error

Report message to a moderator

Re: tablespace problem while import [message #602974 is a reply to message #602973]

Tue, 10 December 2013 10:55

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>i got the same error
Post what you did and got. Verbatim.
And In previous post, I asked to recreate the tabelspace with appropriate settings/large datafile.

Report message to a moderator

Re: tablespace problem while import [message #602975 is a reply to message #602974]

Tue, 10 December 2013 11:01

emadnabil
Messages: 179
Registered: August 2007

Senior Member

Quote:

appropriate settings

what do you mean by this?

I created the new tablespace the same as the old only changed the name from "clinic_2013" to "clinic_2014"
and it is already have a space enough about 30% will be free when import is done (if it is done Cool

Cool

)

Report message to a moderator

Re: tablespace problem while import [message #602976 is a reply to message #602975]

Tue, 10 December 2013 11:08

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Assuming you are still getting ora-1658

ORA-01658:     unable to create INITIAL extent for segment in tablespace string
Cause:     Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created.
Action:     Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with a smaller value for INITIAL

Again,
We dont see what you see unless you post the information.

Report message to a moderator

Re: tablespace problem while import [message #603033 is a reply to message #602959]

Wed, 11 December 2013 02:30

emadnabil
Messages: 179
Registered: August 2007

Senior Member

Quote:

Assuming you are still getting ora-1658
ORA-01658: unable to create INITIAL extent for segment in tablespace string
Cause: Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created.
Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with a smaller value for INITIAL

Again,
We dont see what you see unless you post the information.

I got this error because it always tries to import on tablespace clinic_2013
and that is not required as i created the new user with default tablespace clinic_2014
why the import always go to clinic_2013 ??!!!

Report message to a moderator

Re: tablespace problem while import [message #603040 is a reply to message #603033]

Wed, 11 December 2013 03:04

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Because this is what is in the objects DDL.

Report message to a moderator

Re: tablespace problem while import [message #603044 is a reply to message #602959]

Wed, 11 December 2013 03:11

emadnabil
Messages: 179
Registered: August 2007

Senior Member

Quote:

Because this is what is in the objects DDL.

Thanks for reply
if so why when create new user we gave it a default tablespace

Report message to a moderator

Re: tablespace problem while import [message #603057 is a reply to message #603044]

Wed, 11 December 2013 03:59

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

To allow it to create some objects without giving the tablespace name.

Report message to a moderator

Re: tablespace problem while import [message #603068 is a reply to message #602959]

Wed, 11 December 2013 04:45

emadnabil
Messages: 179
Registered: August 2007

Senior Member

Quote:

To allow it to create some objects without giving the tablespace name.

Doesnot creating user with default tablespace don't force the import to be on that default tablespace
e.g
when importing table does it go for the default tablepsace or the tablespace created in the DDL statement
I think it should go to the default tablespace
otherwise the first tablespace name created should work with me for every import done

or the solution should be moving the tables on the old tablespace to the new tablespace after import on the old
and that's unlogic

Report message to a moderator

Re: tablespace problem while import [message #603071 is a reply to message #603068]

Wed, 11 December 2013 05:03

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No, it does not force (note that all accounts have a default tablespace even if you didn't specify it on creation).
However, it depends on cases.
If the account has no quota on the target tablespace and if it is a top object (table, index, not lob...) then import try to create it in the default tablespace (assuming the account has some quota on it).

Report message to a moderator

Re: tablespace problem while import [message #603083 is a reply to message #603071]

Wed, 11 December 2013 05:49

emadnabil
Messages: 179
Registered: August 2007

Senior Member

Quote:

If the account has no quota on the target tablespace and if it is a top object (table, index, not lob...) then import try to create it in the default tablespace (assuming the account has some quota on it).

and that's doesnot happen as instead it tries to import on the default tablespace of the user created, it import on the old one

Report message to a moderator

Re: tablespace problem while import [message #603084 is a reply to message #603083]

Wed, 11 December 2013 06:09

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

I asked you before: into which schema are you importing? fromuser/touser?

Report message to a moderator

Re: tablespace problem while import [message #603085 is a reply to message #603084]

Wed, 11 December 2013 06:16

emadnabil
Messages: 179
Registered: August 2007

Senior Member

Quote:

I asked you before: into which schema are you importing?

clinic_2014

Quote:

fromuser/touser?

clinic_2013/clincic_2014

Report message to a moderator

Re: tablespace problem while import [message #603088 is a reply to message #603085]

Wed, 11 December 2013 06:22

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Can you not show the command you are running? The export and the import? Copy/paste it, with the output.

Report message to a moderator

Re: tablespace problem while import [message #603090 is a reply to message #603088]

Wed, 11 December 2013 06:48

emadnabil
Messages: 179
Registered: August 2007

Senior Member

the export command

exp CLINIC_2013/CLINIC_2013@orcl1
file=d:\clinic_2014.dmp log=d:\clinic_2014.log statistics=none

the output log


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in AR8MSWIN1256 character set and AL16UTF16 NCHAR character set
server uses AR8ISO8859P6 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user CLINIC_2013 
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user CLINIC_2013 
About to export CLINIC_2013's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export CLINIC_2013's tables via Conventional Path ...
. . exporting table                  ACTION_STATUS      64534 rows exported
. . exporting table             ACTION_STATUS_FLAG          0 rows exported
. . exporting table                       ANALYSIS          0 rows exported
. . exporting table                  APPROVAL_TYPE          2 rows exported
. . exporting table                 APPROVE_DELETE         79 rows exported
. . exporting table                      AUDIT_TAB     165704 rows exported
. . exporting table                      BANK_LIST          3 rows exported
. . exporting table                       CATEGORY          8 rows exported
. . exporting table               CATEGORY_HISTORY          0 rows exported
. . exporting table              CHECK_DEST_HEADER         10 rows exported
. . exporting table          CHECK_DEST_HEADER_HIS         11 rows exported
. . exporting table                CHECK_DEST_LINE       1114 rows exported
. . exporting table            CHECK_DEST_LINE_HIS          4 rows exported
. . exporting table            CLAIM_ENTRY_HISTORY       1118 rows exported
. . exporting table                  CLAIM_HISTORY      63376 rows exported
. . exporting table                   CLAIM_UPDATE        320 rows exported
. . exporting table              CLINIC_SHEET_2012       6766 rows exported
. . exporting table                        COMPANY         14 rows exported
. . exporting table           COMPANY_CHECK_HEADER         10 rows exported
. . exporting table       COMPANY_CHECK_HEADER_HIS         12 rows exported
. . exporting table             COMPANY_CHECK_LINE        268 rows exported
. . exporting table         COMPANY_CHECK_LINE_HIS          1 rows exported
. . exporting table                COMPANY_HISTORY          0 rows exported
. . exporting table                    COST_CENTER        103 rows exported
. . exporting table                       DATE_LOV         48 rows exported
. . exporting table                    DESTINATION        343 rows exported
. . exporting table              DESTINATION_ENTRY       1143 rows exported
. . exporting table      DESTINATION_ENTRY_HISTORY       2662 rows exported
. . exporting table            DESTINATION_HISTORY         54 rows exported
. . exporting table        DESTINATION_RECEIVED_TO          0 rows exported
. . exporting table                       DEST_IMG          0 rows exported
. . exporting table                           DIFF        754 rows exported
. . exporting table                  DOCUMENT_TYPE          3 rows exported
. . exporting table                   DOC_SALARIES         18 rows exported
. . exporting table            EMPLOYEE_CHECK_TEMP          1 rows exported
. . exporting table                 EMPLOYEE_ERROR          0 rows exported
. . exporting table               EMPLOYEE_HISTORY          0 rows exported
. . exporting table                           EMPP         23 rows exported
. . exporting table                          EMP_1         13 rows exported
. . exporting table                          EMP_2         66 rows exported
. . exporting table                       EMP_2012       8986 rows exported
. . exporting table                      EMP_ABUSE         13 rows exported
. . exporting table                  EMP_EXCEPTION          0 rows exported
. . exporting table                   EMP_HOSPITAL        454 rows exported
. . exporting table                  EMP_SHEET2012       8631 rows exported
. . exporting table                        EMP_TEM        522 rows exported
. . exporting table                      EMP_TEMP2          1 rows exported
. . exporting table                   EMP_TEMP2_BK          0 rows exported
. . exporting table                      EMP_TEMP3       7734 rows exported
. . exporting table                      EMP_TEMP4          0 rows exported
. . exporting table                 EMP_TEMP_ERROR        852 rows exported
. . exporting table               EMP_UPLOAD_SHEET        201 rows exported
. . exporting table                     ENTRY_FORM      53594 rows exported
. . exporting table            ENTRY_FORM_COMPLETE          0 rows exported
. . exporting table             ENTRY_FORM_HISTORY     110996 rows exported
. . exporting table                            ENV          1 rows exported
. . exporting table              EXCEPTION_APPROVE          0 rows exported
. . exporting table              EXP_AMOUNT_HEADER         10 rows exported
. . exporting table          EXP_AMOUNT_HEADER_HIS          0 rows exported
. . exporting table                EXP_AMOUNT_LINE        379 rows exported
. . exporting table            EXP_AMOUNT_LINE_HIS          0 rows exported
. . exporting table                       EXP_TYPE          9 rows exported
. . exporting table                       FND_USER         22 rows exported
. . exporting table                      FORM_NAME         66 rows exported
. . exporting table                      FORM_USER        731 rows exported
. . exporting table                             H1          3 rows exported
. . exporting table                      ITEM_TREE         66 rows exported
. . exporting table               JTF_RS_SALESREPS         18 rows exported
. . exporting table                             L1         10 rows exported
. . exporting table                        LOG_INF        118 rows exported
. . exporting table                    MAIL_DOCTOR          3 rows exported
. . exporting table                       MEDICINE      25984 rows exported
. . exporting table                  MEDICINE_DATA          0 rows exported
. . exporting table                   MONTHY_COUNT         12 rows exported
. . exporting table                    MONTHY_NAME         12 rows exported
. . exporting table                        MONTH_D        144 rows exported
. . exporting table               MTL_SYSTEM_ITEMS         58 rows exported
. . exporting table      NOTIFICATION_MAIL_HISTORY         18 rows exported
. . exporting table                  PASSWORD_USER         65 rows exported
. . exporting table        RA_CUSTOMER_DETAILS_ALL      11437 rows exported
. . exporting table        RA_CUSTOMER_DETAILS_BKP      11437 rows exported
. . exporting table            RA_CUSTOMER_TRX_ALL      61503 rows exported
. . exporting table         RA_CUSTOMER_TRX_ALL_BB       5829 rows exported
. . exporting table          RA_CUSTOMER_TRX_ALL_E          0 rows exported
. . exporting table      RA_CUSTOMER_TRX_ALL_ENTRY         54 rows exported
. . exporting table       RA_CUSTOMER_TRX_ALL_HIST        249 rows exported
. . exporting table      RA_CUSTOMER_TRX_LINES_ALL      76136 rows exported
. . exporting table   RA_CUSTOMER_TRX_LINES_ALL_BB      18556 rows exported
. . exporting table    RA_CUSTOMER_TRX_LINES_ALL_E          0 rows exported
. . exporting table RA_CUSTOMER_TRX_LINES_ALL_HIST        451 rows exported
. . exporting table                           RA_H          3 rows exported
. . exporting table                       RA_H2013        473 rows exported
. . exporting table                    RA_H2013_BK        470 rows exported
. . exporting table                   RA_H2013_BK2        470 rows exported
. . exporting table                        RA_HJAN         20 rows exported
. . exporting table                           RA_L          9 rows exported
. . exporting table                       RA_L2013       1511 rows exported
. . exporting table                    RA_L2013_BK       1502 rows exported
. . exporting table                   RA_L2013_BK2       1502 rows exported
. . exporting table                        RA_LJAN         42 rows exported
. . exporting table                        REQUEST          2 rows exported
. . exporting table                   REQUEST_TYPE         10 rows exported
. . exporting table                 SALESPERSONS_N         47 rows exported
. . exporting table                   SUB_CATEGORY         10 rows exported
. . exporting table                          TEMP0       7430 rows exported
. . exporting table                          TEMP1       7703 rows exported
. . exporting table                          TEMP2       7433 rows exported
. . exporting table                          TEMP3       7431 rows exported
. . exporting table                          TEMP4       7431 rows exported
. . exporting table                       TOTAL_PH       7638 rows exported
. . exporting table              UPLOAD_MONTH_INFO         98 rows exported
. . exporting table                     USER_AUDIT         43 rows exported
. . exporting table                      USER_DATA        208 rows exported
. . exporting table                      USER_HOST         24 rows exported
. . exporting table                      USER_INFO       5695 rows exported
. . exporting table           VISIT_HEADER_HISTORY      67570 rows exported
. . exporting table            VISIT_LINES_HISTORY     126581 rows exported
. . exporting table                              X         68 rows exported
. . exporting table                              Y         68 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

the import command

imp clinic_2014/clinic_2014@orcl2 file=d:\CLINIC_2014.DMP log=d:\CLINIC_2014.
log FULL=Y

the import log


Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by CLINIC_2013, not by you

import done in AR8MSWIN1256 character set and AL16UTF16 NCHAR character set
import server uses AR8ISO8859P6 character set (possible charset conversion)
. importing CLINIC_2013's objects into CLINIC_2014
. . importing table                "ACTION_STATUS"      64534 rows imported
. . importing table           "ACTION_STATUS_FLAG"          0 rows imported
. . importing table                     "ANALYSIS"          0 rows imported
. . importing table                "APPROVAL_TYPE"          2 rows imported
. . importing table               "APPROVE_DELETE"         79 rows imported
. . importing table                    "AUDIT_TAB"     165704 rows imported
. . importing table                    "BANK_LIST"          3 rows imported
. . importing table                     "CATEGORY"          8 rows imported
. . importing table             "CATEGORY_HISTORY"          0 rows imported
. . importing table            "CHECK_DEST_HEADER"         10 rows imported
. . importing table        "CHECK_DEST_HEADER_HIS"         11 rows imported
. . importing table              "CHECK_DEST_LINE"       1114 rows imported
. . importing table          "CHECK_DEST_LINE_HIS"          4 rows imported
. . importing table          "CLAIM_ENTRY_HISTORY"       1118 rows imported
. . importing table                "CLAIM_HISTORY"      63376 rows imported
. . importing table                 "CLAIM_UPDATE"        320 rows imported
. . importing table            "CLINIC_SHEET_2012"       6766 rows imported
. . importing table                      "COMPANY"         14 rows imported
. . importing table         "COMPANY_CHECK_HEADER"         10 rows imported
. . importing table     "COMPANY_CHECK_HEADER_HIS"         12 rows imported
. . importing table           "COMPANY_CHECK_LINE"        268 rows imported
. . importing table       "COMPANY_CHECK_LINE_HIS"          1 rows imported
. . importing table              "COMPANY_HISTORY"          0 rows imported
. . importing table                  "COST_CENTER"        103 rows imported
. . importing table                     "DATE_LOV"         48 rows imported
. . importing table                  "DESTINATION"        343 rows imported
. . importing table            "DESTINATION_ENTRY"       1143 rows imported
. . importing table    "DESTINATION_ENTRY_HISTORY"       2662 rows imported
. . importing table          "DESTINATION_HISTORY"         54 rows imported
. . importing table      "DESTINATION_RECEIVED_TO"          0 rows imported
. . importing table                     "DEST_IMG"          0 rows imported
. . importing table                         "DIFF"        754 rows imported
. . importing table                "DOCUMENT_TYPE"          3 rows imported
. . importing table                 "DOC_SALARIES"         18 rows imported
. . importing table          "EMPLOYEE_CHECK_TEMP"          1 rows imported
. . importing table               "EMPLOYEE_ERROR"          0 rows imported
. . importing table             "EMPLOYEE_HISTORY"          0 rows imported
. . importing table                         "EMPP"         23 rows imported
. . importing table                        "EMP_1"         13 rows imported
. . importing table                        "EMP_2"         66 rows imported
. . importing table                     "EMP_2012"       8986 rows imported
. . importing table                    "EMP_ABUSE"         13 rows imported
. . importing table                "EMP_EXCEPTION"          0 rows imported
. . importing table                 "EMP_HOSPITAL"        454 rows imported
. . importing table                "EMP_SHEET2012"       8631 rows imported
. . importing table                      "EMP_TEM"        522 rows imported
. . importing table                    "EMP_TEMP2"          1 rows imported
. . importing table                 "EMP_TEMP2_BK"          0 rows imported
. . importing table                    "EMP_TEMP3"       7734 rows imported
. . importing table                    "EMP_TEMP4"          0 rows imported
. . importing table               "EMP_TEMP_ERROR"        852 rows imported
. . importing table             "EMP_UPLOAD_SHEET"        201 rows imported
. . importing table                   "ENTRY_FORM"      53594 rows imported
. . importing table          "ENTRY_FORM_COMPLETE"          0 rows imported
. . importing table           "ENTRY_FORM_HISTORY"     110996 rows imported
. . importing table                          "ENV"          1 rows imported
. . importing table            "EXCEPTION_APPROVE"          0 rows imported
. . importing table            "EXP_AMOUNT_HEADER"         10 rows imported
. . importing table        "EXP_AMOUNT_HEADER_HIS"          0 rows imported
. . importing table              "EXP_AMOUNT_LINE"        379 rows imported
. . importing table          "EXP_AMOUNT_LINE_HIS"          0 rows imported
. . importing table                     "EXP_TYPE"          9 rows imported
. . importing table                     "FND_USER"         22 rows imported
. . importing table                    "FORM_NAME"         66 rows imported
. . importing table                    "FORM_USER"        731 rows imported
. . importing table                           "H1"          3 rows imported
. . importing table                    "ITEM_TREE"         66 rows imported
. . importing table             "JTF_RS_SALESREPS"         18 rows imported
. . importing table                           "L1"         10 rows imported
. . importing table                      "LOG_INF"        118 rows imported
. . importing table                  "MAIL_DOCTOR"          3 rows imported
. . importing table                     "MEDICINE"      25984 rows imported
. . importing table                "MEDICINE_DATA"          0 rows imported
. . importing table                 "MONTHY_COUNT"         12 rows imported
. . importing table                  "MONTHY_NAME"         12 rows imported
. . importing table                      "MONTH_D"        144 rows imported
. . importing table             "MTL_SYSTEM_ITEMS"         58 rows imported
. . importing table    "NOTIFICATION_MAIL_HISTORY"         18 rows imported
. . importing table                "PASSWORD_USER"         65 rows imported
. . importing table      "RA_CUSTOMER_DETAILS_ALL"      11437 rows imported
. . importing table      "RA_CUSTOMER_DETAILS_BKP"      11437 rows imported
IMP-00017: following statement failed with ORACLE error 1659:
 "CREATE TABLE "RA_CUSTOMER_TRX_ALL" ("CUSTOMER_TRX_ID" NUMBER(15, 0), "LAST_"
 "UPDATE_DATE" DATE, "LAST_UPDATED_BY" NUMBER(15, 0), "CREATION_DATE" DATE, ""
 "CREATED_BY" NUMBER(15, 0), "LAST_UPDATE_LOGIN" NUMBER(15, 0), "TRX_NUMBER" "
 "NUMBER NOT NULL ENABLE, "TRX_DATE" DATE, "SOLD_TO_CUSTOMER_ID" VARCHAR2(50)"
 " NOT NULL ENABLE, "CUSTOMER_REFERENCE" VARCHAR2(300), "REQUEST_ID" NUMBER(1"
 "5, 0), "COMPLETE_FLAG" VARCHAR2(1), "PRIMARY_SALESREP_ID" NUMBER, "LOCATION"
 "" VARCHAR2(30), "NET_AMOUNT" NUMBER, "REQUEST_TYPE" VARCHAR2(20), "DISTINAT"
 "ION_CODE" NUMBER, "DIAGANOSTIC" VARCHAR2(500), "MONTHLY_RECURRING" VARCHAR2"
 "(2), "FLAG" VARCHAR2(2), "PRINTED_FLAG" VARCHAR2(2), "NO_OF_COPY" NUMBER, ""
 "DELETED" VARCHAR2(2), "ENTERY_NO" NUMBER, "MONTH_DATE" VARCHAR2(30), "DES_N"
 "O" NUMBER, "SERVICE" VARCHAR2(100), "NET_AMOUNT_ORG" NUMBER, "APPROVE" VARC"
 "HAR2(100), "COMPANY" VARCHAR2(30), "SUB_CAT_CODE" NUMBER, "CATEGORY_CODE" N"
 "UMBER, "DURATION" NUMBER, "DISC" NUMBER, "EMERGENCY" VARCHAR2(1), "REFERENC"
 "E" VARCHAR2(100), "PRINTED_BY" NUMBER, "PRINTED_DATE" DATE, "EXCEPTIONS" VA"
 "RCHAR2(2), "EXP_AMOUNT" NUMBER, "EXP_COM_AMOUNT" NUMBER, "EXP_EMP_AMOUNT" N"
 "UMBER, "EMP_MEDICAL_PROGRAM" NUMBER)  PCTFREE 10 PCTUSED 40 INITRANS 10 MAX"
 "TRANS 255 STORAGE(INITIAL 34603008 FREELISTS 1 FREELIST GROUPS 1) TABLESPAC"
 "E "CLINIC_2013" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1659 encountered
ORA-01659: unable to allocate MINEXTENTS beyond 4 in tablespace CLINIC_2013
. . importing table       "RA_CUSTOMER_TRX_ALL_BB"       5829 rows imported
. . importing table        "RA_CUSTOMER_TRX_ALL_E"          0 rows imported
. . importing table    "RA_CUSTOMER_TRX_ALL_ENTRY"         54 rows imported
. . importing table     "RA_CUSTOMER_TRX_ALL_HIST"        249 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE TABLE "RA_CUSTOMER_TRX_LINES_ALL" ("CUSTOMER_TRX_LINE_ID" NUMBER(15,"
 " 0) NOT NULL ENABLE, "LAST_UPDATE_DATE" DATE, "LAST_UPDATED_BY" NUMBER(15, "
 "0), "CREATION_DATE" DATE, "CREATED_BY" NUMBER(15, 0), "LAST_UPDATE_LOGIN" N"
 "UMBER(15, 0), "CUSTOMER_TRX_ID" NUMBER(15, 0), "LINE_NUMBER" NUMBER, "INVEN"
 "TORY_ITEM_ID" NUMBER(15, 0), "DESCRIPTION" VARCHAR2(240), "QUANTITY_ORDERED"
 "" NUMBER, "UNIT_SELLING_PRICE" NUMBER, "LINE_TYPE" VARCHAR2(20), "EXTENDED_"
 "AMOUNT" NUMBER, "ENTERY_NO" NUMBER, "DES_NO" NUMBER, "POSTINGSTATUS" NUMBER"
 ", "DISC_TYPE" VARCHAR2(30), "DISC_REASON" VARCHAR2(200), "SPECIAL_DISC" NUM"
 "BER, "DISC" NUMBER, "ACTUAL_PRICE" NUMBER, "ACTUAL_AMOUNT" NUMBER, "VARIANC"
 "E" NUMBER)  PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255 STORAGE(INITIAL "
 "109051904 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "CLINIC_2013" LOGGING N"
 "OCOMPRESS"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CLINIC_2013
. . importing table "RA_CUSTOMER_TRX_LINES_ALL_BB"      18556 rows imported
. . importing table  "RA_CUSTOMER_TRX_LINES_ALL_E"          0 rows imported
. . importing table "RA_CUSTOMER_TRX_LINES_ALL_HIST"        451 rows imported
. . importing table                         "RA_H"          3 rows imported
. . importing table                     "RA_H2013"        473 rows imported
. . importing table                  "RA_H2013_BK"        470 rows imported
. . importing table                 "RA_H2013_BK2"        470 rows imported
. . importing table                      "RA_HJAN"         20 rows imported
. . importing table                         "RA_L"          9 rows imported
. . importing table                     "RA_L2013"       1511 rows imported
. . importing table                  "RA_L2013_BK"       1502 rows imported
. . importing table                 "RA_L2013_BK2"       1502 rows imported
. . importing table                      "RA_LJAN"         42 rows imported
. . importing table                      "REQUEST"          2 rows imported
. . importing table                 "REQUEST_TYPE"         10 rows imported
. . importing table               "SALESPERSONS_N"         47 rows imported
. . importing table                 "SUB_CATEGORY"         10 rows imported
. . importing table                        "TEMP0"
IMP-00058: ORACLE error 1653 encountered
ORA-01653: unable to extend table CLINIC_2014.TEMP0 by 128 in tablespace CLINIC_2013
IMP-00028: partial import of previous table rolled back: 6569 rows rolled back
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE TABLE "TEMP1" ("CUSTOMER_ID" VARCHAR2(50) NOT NULL ENABLE, "CUSTOMER"
 "_NAME" VARCHAR2(50), "LAST_UPDATED_DATE" DATE, "LAST_UPDATED_BY" NUMBER, "C"
 "REATION_DATE" DATE, "CREATED_BY" NUMBER, "COMPANY" VARCHAR2(50), "LOCATION""
 " VARCHAR2(50), "PHONE" VARCHAR2(50), "EMAIL" VARCHAR2(50), "ADDRESS" VARCHA"
 "R2(250), "DESTINATION_LIMIT" NUMBER(15, 0), "DOCTOR_LIMIT" NUMBER(15, 0), ""
 "MEDICINE_LIMIT" NUMBER(15, 0), "MONTHLY_ALLOWED" NUMBER(15, 2), "OVER_FLOW""
 " CHAR(1), "COST_CENTER" VARCHAR2(50), "DATE_TO" DATE, "DEPT" VARCHAR2(50), "
 ""JOB_DESC" VARCHAR2(100), "BIRTH_DATE" DATE, "JOB_DATE" DATE, "MEDICINE_DAT"
 "E" DATE, "SYSTEM_DATE" DATE, "PROCESS" VARCHAR2(100), "JOB_DGREE" VARCHAR2("
 "200), "MEDICAL_PROGRAM" VARCHAR2(200))  PCTFREE 10 PCTUSED 40 INITRANS 1 MA"
 "XTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "
 ""CLINIC_2013" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CLINIC_2013
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE TABLE "TEMP2" ("CUSTOMER_ID" VARCHAR2(50) NOT NULL ENABLE, "CUSTOMER"
 "_NAME" VARCHAR2(50), "LAST_UPDATED_DATE" DATE, "LAST_UPDATED_BY" NUMBER, "C"
 "REATION_DATE" DATE, "CREATED_BY" NUMBER, "COMPANY" VARCHAR2(50), "LOCATION""
 " VARCHAR2(50), "PHONE" VARCHAR2(50), "EMAIL" VARCHAR2(50), "ADDRESS" VARCHA"
 "R2(250), "DESTINATION_LIMIT" NUMBER(15, 0), "DOCTOR_LIMIT" NUMBER(15, 0), ""
 "MEDICINE_LIMIT" NUMBER(15, 0), "MONTHLY_ALLOWED" NUMBER(15, 2), "OVER_FLOW""
 " CHAR(1), "COST_CENTER" VARCHAR2(50), "DATE_TO" DATE, "DEPT" VARCHAR2(50), "
 ""JOB_DESC" VARCHAR2(100), "BIRTH_DATE" DATE, "JOB_DATE" DATE, "MEDICINE_DAT"
 "E" DATE, "SYSTEM_DATE" DATE, "PROCESS" VARCHAR2(100), "JOB_DGREE" VARCHAR2("
 "200), "MEDICAL_PROGRAM" VARCHAR2(200))  PCTFREE 10 PCTUSED 40 INITRANS 1 MA"
 "XTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "
 ""CLINIC_2013" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CLINIC_2013
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE TABLE "TEMP3" ("CUSTOMER_ID" VARCHAR2(50) NOT NULL ENABLE, "CUSTOMER"
 "_NAME" VARCHAR2(50), "LAST_UPDATED_DATE" DATE, "LAST_UPDATED_BY" NUMBER, "C"
 "REATION_DATE" DATE, "CREATED_BY" NUMBER, "COMPANY" VARCHAR2(50), "LOCATION""
 " VARCHAR2(50), "PHONE" VARCHAR2(50), "EMAIL" VARCHAR2(50), "ADDRESS" VARCHA"
 "R2(250), "DESTINATION_LIMIT" NUMBER(15, 0), "DOCTOR_LIMIT" NUMBER(15, 0), ""
 "MEDICINE_LIMIT" NUMBER(15, 0), "MONTHLY_ALLOWED" NUMBER(15, 2), "OVER_FLOW""
 " CHAR(1), "COST_CENTER" VARCHAR2(50), "DATE_TO" DATE, "DEPT" VARCHAR2(50), "
 ""JOB_DESC" VARCHAR2(100), "BIRTH_DATE" DATE, "JOB_DATE" DATE, "MEDICINE_DAT"
 "E" DATE, "SYSTEM_DATE" DATE, "PROCESS" VARCHAR2(100), "JOB_DGREE" VARCHAR2("
 "200), "MEDICAL_PROGRAM" VARCHAR2(200))  PCTFREE 10 PCTUSED 40 INITRANS 1 MA"
 "XTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "
 ""CLINIC_2013" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CLINIC_2013
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE TABLE "TEMP4" ("CUSTOMER_ID" VARCHAR2(50) NOT NULL ENABLE, "CUSTOMER"
 "_NAME" VARCHAR2(50), "LAST_UPDATED_DATE" DATE, "LAST_UPDATED_BY" NUMBER, "C"
 "REATION_DATE" DATE, "CREATED_BY" NUMBER, "COMPANY" VARCHAR2(50), "LOCATION""
 " VARCHAR2(50), "PHONE" VARCHAR2(50), "EMAIL" VARCHAR2(50), "ADDRESS" VARCHA"
 "R2(250), "DESTINATION_LIMIT" NUMBER(15, 0), "DOCTOR_LIMIT" NUMBER(15, 0), ""
 "MEDICINE_LIMIT" NUMBER(15, 0), "MONTHLY_ALLOWED" NUMBER(15, 2), "OVER_FLOW""
 " CHAR(1), "COST_CENTER" VARCHAR2(50), "DATE_TO" DATE, "DEPT" VARCHAR2(50), "
 ""JOB_DESC" VARCHAR2(100), "BIRTH_DATE" DATE, "JOB_DATE" DATE, "MEDICINE_DAT"
 "E" DATE, "SYSTEM_DATE" DATE, "PROCESS" VARCHAR2(100), "JOB_DGREE" VARCHAR2("
 "200), "MEDICAL_PROGRAM" VARCHAR2(200))  PCTFREE 10 PCTUSED 40 INITRANS 1 MA"
 "XTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "
 ""CLINIC_2013" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CLINIC_2013
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE TABLE "TOTAL_PH" ("CUSTOMER_TRX_ID" NUMBER(15, 0), "SERVICE" VARCHAR"
 "2(100), "TRX_NUMBER" NUMBER NOT NULL ENABLE, "TRX_DATE" DATE, "SOLD_TO_CUST"
 "OMER_ID" VARCHAR2(50) NOT NULL ENABLE, "REQUEST_TYPE" VARCHAR2(20), "DISTIN"
 "ATION_CODE" NUMBER, "COMPANY" VARCHAR2(30), "CODE" NUMBER NOT NULL ENABLE, "
 ""CAT_NAME" VARCHAR2(100), "CAT_NAME_AR" VARCHAR2(200), "SUB_CAT_NAME" VARCH"
 "AR2(200), "NAME" VARCHAR2(400), "NET" NUMBER, "NAME_AR" VARCHAR2(200), "CUS"
 "TOMER_NAME" VARCHAR2(50))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 ST"
 "ORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "CLINIC_2013""
 " LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CLINIC_2013
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE TABLE "UPLOAD_MONTH_INFO" ("UPLOAD_DATE" DATE, "UPLOAD_MONTH" VARCHA"
 "R2(100), "USER_ID" NUMBER, "HOSTNAME" VARCHAR2(200))  PCTFREE 10 PCTUSED 40"
 " INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS "
 "1) TABLESPACE "CLINIC_2013" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CLINIC_2013
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE TABLE "USER_AUDIT" ("ID" NUMBER, "TERMINAL" VARCHAR2(100), "IP" VARC"
 "HAR2(100), "OLD_IP" VARCHAR2(100), "HOSTNAME" VARCHAR2(100))  PCTFREE 10 PC"
 "TUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST"
 " GROUPS 1) TABLESPACE "CLINIC_2013" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CLINIC_2013
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE TABLE "USER_DATA" ("IPADDRESS" VARCHAR2(30), "HOSTNAME" VARCHAR2(300"
 "), "USER_NAME" VARCHAR2(300))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 25"
 "5 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "CLINIC_2"
 "013" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CLINIC_2013
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE TABLE "USER_HOST" ("HOSTNAME" VARCHAR2(300), "USER_NAME" VARCHAR2(30"
 "0))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FR"
 "EELISTS 1 FREELIST GROUPS 1) TABLESPACE "CLINIC_2013" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CLINIC_2013
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE TABLE "USER_INFO" ("HOST_NAME" VARCHAR2(30), "USER_NAME" VARCHAR2(30"
 "), "IPADDRESS" VARCHAR2(30), "LOGIN_DATE" DATE)  PCTFREE 10 PCTUSED 40 INIT"
 "RANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TA"
 "BLESPACE "CLINIC_2013" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CLINIC_2013
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE TABLE "VISIT_HEADER_HISTORY" ("CUSTOMER_TRX_ID" NUMBER(15, 0), "TRX_"
 "NUMBER" NUMBER, "TRX_DATE" DATE, "SOLD_TO_CUSTOMER_ID" VARCHAR2(50), "REQUE"
 "ST_ID" NUMBER(15, 0), "COMPLETE_FLAG" VARCHAR2(1), "PRIMARY_SALESREP_ID" NU"
 "MBER, "NET_AMOUNT" NUMBER, "REQUEST_TYPE" VARCHAR2(20), "DISTINATION_CODE" "
 "NUMBER, "DIAGANOSTIC" VARCHAR2(500), "MONTHLY_RECURRING" VARCHAR2(2), "FLAG"
 "" VARCHAR2(2), "PRINTED_FLAG" VARCHAR2(2), "ENTERY_NO" NUMBER, "MONTH_DATE""
 " VARCHAR2(30), "DES_NO" NUMBER, "SERVICE" VARCHAR2(100), "NET_AMOUNT_ORG" N"
 "UMBER, "APPROVE" VARCHAR2(100), "COMPANY" VARCHAR2(20), "CHANGE_FILED" VARC"
 "HAR2(200), "OLD_VALUE" VARCHAR2(200), "NEW_VALUE" VARCHAR2(200), "MODIFIED_"
 "DATE" DATE, "MODIFIED_USER" VARCHAR2(200), "PROCESS" VARCHAR2(200), "SUB_CA"
 "T_CODE" NUMBER, "CATEGORY_CODE" NUMBER, "DURATION" NUMBER, "EMERGENCY" VARC"
 "HAR2(1), "DISC" NUMBER)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STOR"
 "AGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "CLINIC_2013" L"
 "OGGING NOCOMPRESS"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CLINIC_2013
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE TABLE "VISIT_LINES_HISTORY" ("CUSTOMER_TRX_LINE_ID" NUMBER, "CUSTOME"
 "R_TRX_ID" NUMBER(15, 0), "INVENTORY_ITEM_ID" NUMBER(15, 0), "DESCRIPTION" V"
 "ARCHAR2(240), "QUANTITY_ORDERED" NUMBER, "UNIT_SELLING_PRICE" NUMBER, "LINE"
 "_TYPE" VARCHAR2(20), "EXTENDED_AMOUNT" NUMBER, "ENTERY_NO" NUMBER, "DES_NO""
 " NUMBER, "DISC_TYPE" VARCHAR2(30), "DISC_REASON" VARCHAR2(200), "SPECIAL_DI"
 "SC" NUMBER, "CHANGE_FILED" VARCHAR2(200), "OLD_VALUE" VARCHAR2(200), "NEW_V"
 "ALUE" VARCHAR2(200), "MODIFIED_DATE" DATE, "MODIFIED_USER" VARCHAR2(200), ""
 "PROCESS" VARCHAR2(200))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STOR"
 "AGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "CLINIC_2013" L"
 "OGGING NOCOMPRESS"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CLINIC_2013
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE TABLE "X" ("DES_NO" NUMBER, "AMO" NUMBER)  PCTFREE 10 PCTUSED 40 INI"
 "TRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) T"
 "ABLESPACE "CLINIC_2013" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CLINIC_2013
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE TABLE "Y" ("DES_NO" NUMBER NOT NULL ENABLE, "AMO" NUMBER)  PCTFREE 1"
 "0 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREE"
 "LIST GROUPS 1) TABLESPACE "CLINIC_2013" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CLINIC_2013
About to enable constraints...
Import terminated successfully with warnings.

Report message to a moderator

Re: tablespace problem while import [message #603092 is a reply to message #603090]

Wed, 11 December 2013 06:52

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

You are importing into the clinic_2013 schema. Why did you say you were using touser/fromuser?
Telling lies about what you are doing wastes everyone's time, you know.

Report message to a moderator

Re: tablespace problem while import [message #603093 is a reply to message #603092]

Wed, 11 December 2013 07:00

emadnabil
Messages: 179
Registered: August 2007

Senior Member

Quote:

Why did you say you were using touser/fromuser?
Telling lies about what you are doing wastes everyone's time, you know.

where i said that i import using touser/fromuser

Report message to a moderator

Re: tablespace problem while import [message #603096 is a reply to message #603093]

Wed, 11 December 2013 07:28

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You should use it as this is what you want to do.

Report message to a moderator

Re: tablespace problem while import [message #603098 is a reply to message #603093]

Wed, 11 December 2013 07:30

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>where i said that i import using touser/fromuser

Here.

Quote:

Quote:
Add a fromuser/touser clause?

tested and didnot work

What a waste of time.

Report message to a moderator

Re: tablespace problem while import [message #603105 is a reply to message #603098]

Wed, 11 December 2013 07:55

emadnabil
Messages: 179
Registered: August 2007

Senior Member

Quote:

Add a fromuser/touser clause?

that what you asked me to try
as you asked me to try
Quote:

Please export with compress=n and try again

and
Quote:

remove the resource role

That's all what you asked me to try
but I didn't say that i am importing by this paramerter fromuser/touser

didn't you read the first post !!!

Report message to a moderator

Re: tablespace problem while import [message #603108 is a reply to message #603105]

Wed, 11 December 2013 08:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

imp utility will place objects into the same tablespace from where they originated by default.
If you want objects to reside in new/different tablespace, then the object must be manually created in new/different tablespace prior to starting imp utility.

Report message to a moderator

Re: tablespace problem while import [message #603111 is a reply to message #603105]

Wed, 11 December 2013 08:27

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And did you do it?
If so copy and paste this session.

Report message to a moderator

Re: tablespace problem while import [message #603122 is a reply to message #603111]

Wed, 11 December 2013 09:04

emadnabil
Messages: 179
Registered: August 2007

Senior Member

yes we now are doing it manually as we didn't get any automated solution
by the results of this sql statments


select 'ALTER TABLE '||DD.segment_name||' MOVE TABLESPACE CLINIC_2014;' from dba_segments DD
WHERE DD.owner ='CLINIC_2014'
AND DD.segment_type ='TABLE'


select 'ALTER INDEX '||DD.segment_name||' REBUILD TABLESPACE CLINIC_INDEX;' from dba_segments DD
WHERE DD.owner ='CLINIC_2014'
AND DD.segment_type ='INDEX'

Report message to a moderator

Re: tablespace problem while import [message #603131 is a reply to message #603122]

Wed, 11 December 2013 09:58

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes you have we did explain you how to do it but you didn't read it.

Report message to a moderator

Re: tablespace problem while import [message #603148 is a reply to message #602959]

Wed, 11 December 2013 14:49

emadnabil
Messages: 179
Registered: August 2007

Senior Member

No I read it
But this solution was not accepted for us as it is manually done
So we are going to open an SR on metalink

Report message to a moderator

Re: tablespace problem while import [message #603152 is a reply to message #603148]

Wed, 11 December 2013 14:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

emadnabil wrote on Wed, 11 December 2013 12:49

So we are going to open an SR on metalink

>tablespace problem while import (9i)
Good Luck with getting any meaningful response on the obsoleted & unsupported version V9

Report message to a moderator

Re: tablespace problem while import [message #603404 is a reply to message #602973]

Mon, 16 December 2013 00:33

hkchital
Messages: 128
Registered: September 2008
Location: Singapore

Senior Member

CLINIC_2014 has been granted both the privilege and the role UNLIMITED TABLESPACE and DBA (the RESOURCE role also included the UNLIMITED TABLESPACE privilege). This allows it to import objects back into the same tablespace. Only if CLINIC_2014 did not have these privileges would it then import into CLINIC_2014 tablespace. You should create CLINIC_2014 with ALTER USER CLINIC_2014 QUOTA UNLIMITED ON CLINIC_2014 but not with the UNLIMITED TABLESPACE privilege and not with the DBA role.

Note : Without the DBA role granted to CLINIC_2014, you must login to imp with an account with the DBA role but use FROMUSER/TOUSER for the user mapping.

Hemant K Chitale

Report message to a moderator

Previous Topic:	Need help: reuse option in datafile!!!
Next Topic:	restore database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 23:41:53 CST 2025