Home » RDBMS Server » Backup & Recovery » tablespace problem while import (9i)
tablespace problem while import [message #602959] Tue, 10 December 2013 10:06 Go to next message
emadnabil
Messages: 171
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

Re: tablespace problem while import [message #602963 is a reply to message #602959] Tue, 10 December 2013 10:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please export with compress=n and try again.
Re: tablespace problem while import [message #602964 is a reply to message #602959] Tue, 10 December 2013 10:21 Go to previous messageGo to next message
John Watson
Messages: 8922
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?
Re: tablespace problem while import [message #602965 is a reply to message #602963] Tue, 10 December 2013 10:21 Go to previous messageGo to next message
emadnabil
Messages: 171
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
Re: tablespace problem while import [message #602968 is a reply to message #602965] Tue, 10 December 2013 10:24 Go to previous messageGo to next message
emadnabil
Messages: 171
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"

Re: tablespace problem while import [message #602970 is a reply to message #602968] Tue, 10 December 2013 10:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 Go to previous messageGo to next message
emadnabil
Messages: 171
Registered: August 2007
Senior Member
Quote:
Add a fromuser/touser clause?


tested and didnot work
Re: tablespace problem while import [message #602972 is a reply to message #602971] Tue, 10 December 2013 10:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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.
Re: tablespace problem while import [message #602973 is a reply to message #602972] Tue, 10 December 2013 10:51 Go to previous messageGo to next message
emadnabil
Messages: 171
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

Re: tablespace problem while import [message #602974 is a reply to message #602973] Tue, 10 December 2013 10:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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.
Re: tablespace problem while import [message #602975 is a reply to message #602974] Tue, 10 December 2013 11:01 Go to previous messageGo to next message
emadnabil
Messages: 171
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 )

Re: tablespace problem while import [message #602976 is a reply to message #602975] Tue, 10 December 2013 11:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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.
Re: tablespace problem while import [message #603033 is a reply to message #602959] Wed, 11 December 2013 02:30 Go to previous messageGo to next message
emadnabil
Messages: 171
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 ??!!!


Re: tablespace problem while import [message #603040 is a reply to message #603033] Wed, 11 December 2013 03:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Because this is what is in the objects DDL.
Re: tablespace problem while import [message #603044 is a reply to message #602959] Wed, 11 December 2013 03:11 Go to previous messageGo to next message
emadnabil
Messages: 171
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
Re: tablespace problem while import [message #603057 is a reply to message #603044] Wed, 11 December 2013 03:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: tablespace problem while import [message #603068 is a reply to message #602959] Wed, 11 December 2013 04:45 Go to previous messageGo to next message
emadnabil
Messages: 171
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


Re: tablespace problem while import [message #603071 is a reply to message #603068] Wed, 11 December 2013 05:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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).

Re: tablespace problem while import [message #603083 is a reply to message #603071] Wed, 11 December 2013 05:49 Go to previous messageGo to next message
emadnabil
Messages: 171
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
Re: tablespace problem while import [message #603084 is a reply to message #603083] Wed, 11 December 2013 06:09 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I asked you before: into which schema are you importing? fromuser/touser?
Re: tablespace problem while import [message #603085 is a reply to message #603084] Wed, 11 December 2013 06:16 Go to previous messageGo to next message
emadnabil
Messages: 171
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
Re: tablespace problem while import [message #603088 is a reply to message #603085] Wed, 11 December 2013 06:22 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: tablespace problem while import [message #603090 is a reply to message #603088] Wed, 11 December 2013 06:48 Go to previous messageGo to next message
emadnabil
Messages: 171
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.

Re: tablespace problem while import [message #603092 is a reply to message #603090] Wed, 11 December 2013 06:52 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: tablespace problem while import [message #603093 is a reply to message #603092] Wed, 11 December 2013 07:00 Go to previous messageGo to next message
emadnabil
Messages: 171
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
Re: tablespace problem while import [message #603096 is a reply to message #603093] Wed, 11 December 2013 07:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You should use it as this is what you want to do.
Re: tablespace problem while import [message #603098 is a reply to message #603093] Wed, 11 December 2013 07:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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.
Re: tablespace problem while import [message #603105 is a reply to message #603098] Wed, 11 December 2013 07:55 Go to previous messageGo to next message
emadnabil
Messages: 171
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 !!!
Re: tablespace problem while import [message #603108 is a reply to message #603105] Wed, 11 December 2013 08:15 Go to previous messageGo to next message
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.
Re: tablespace problem while import [message #603111 is a reply to message #603105] Wed, 11 December 2013 08:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: tablespace problem while import [message #603122 is a reply to message #603111] Wed, 11 December 2013 09:04 Go to previous messageGo to next message
emadnabil
Messages: 171
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'
Re: tablespace problem while import [message #603131 is a reply to message #603122] Wed, 11 December 2013 09:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: tablespace problem while import [message #603148 is a reply to message #602959] Wed, 11 December 2013 14:49 Go to previous messageGo to next message
emadnabil
Messages: 171
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

Re: tablespace problem while import [message #603152 is a reply to message #603148] Wed, 11 December 2013 14:57 Go to previous messageGo to next message
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
Re: tablespace problem while import [message #603404 is a reply to message #602973] Mon, 16 December 2013 00:33 Go to previous message
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
Previous Topic: Need help: reuse option in datafile!!!
Next Topic: restore database
Goto Forum:
  


Current Time: Thu Mar 28 16:20:04 CDT 2024