Home » RDBMS Server » Server Utilities » IMP Problem "the objects were exported by FINANCE, not by you"
IMP Problem "the objects were exported by FINANCE, not by you" [message #163644] |
Fri, 17 March 2006 11:55 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sharma.radha
Messages: 59 Registered: August 2005 Location: mumbai
|
Member |
![123](/forum/theme/orafaq/images/icq.png)
|
|
Hi to all,
I am getting the LOG when i import schema FINANCE.
The log file show
Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
Export file created by EXPORT:V09.00.01 via direct path
Warning: the objects were exported by FINANCE, not by you
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing FINANCE's objects into SYSTEM
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SEQ_1" MINVALUE 1 MAXVALUE 999999999999999999999999999 INC"
"REMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "APPROVAL_DETAILS" ("APPROVAL_NO" VARCHAR2(10), "ITEM_COD" VAR"
"CHAR2(6), "QUANTITY" NUMBER(4, 0), "AMOUNT" NUMBER(15, 2), "RECEIVED_QTY" N"
"UMBER(4, 0), "STATUS" CHAR(1), "CREATED_BY" VARCHAR2(25), "CREATED_ON" DATE"
", "MODIFIED_BY" VARCHAR2(25), "MODIFIED_ON" DATE) PCTFREE 10 PCTUSED 40 IN"
"ITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) "
" LOGGING"
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "APPROVAL_MASTER" ("APPROVAL_NO" VARCHAR2(10), "APPROVAL_DATE""
" DATE NOT NULL ENABLE, "BUDGET_HEAD" VARCHAR2(25), "SL_NO_POWERS" VARCHAR2("
"5), "EXPENSE_TYPE" VARCHAR2(10), "ESTIMATED_AMOUNT" NUMBER(15, 2), "APPROVE"
"D" CHAR(1), "REMARKS" VARCHAR2(200), "CREATED_BY" VARCHAR2(25), "CREATED_ON"
"" DATE, "MODIFIED_BY" VARCHAR2(25), "MODIFIED_ON" DATE, "APPROVED_PRINCIPLE"
"" NUMBER(15, 2), "PROPOSER" VARCHAR2(10), "REASON" VARCHAR2(500), "SIG_AUTH"
"" CHAR(3), "FILE_NAME" VARCHAR2(10), "CB_SYSTEM_NO" NUMBER(8, 0), "GROUP_ID"
"" NUMBER(2, 0), "TRANS" VARCHAR2(32)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAX"
"TRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) "
" LOGGING" " IF TO_CHAR(DATE_IN,'MM') > 3 THEN"
" FIN_YEAR:=TO_CHAR(DATE_IN,'YYYY')||'-'||TO_CHAR(TO_NUMBER(TO_CHAR(DATE_I"
"N,'YYYY'))+1);"
" ELSE"
" FIN_YEAR:=TO_CHAR(TO_NUMBER(TO_CHAR(DATE_IN,'YYYY'))-1)||'-'||TO_CHAR(DA"
"TE_IN,'YYYY');"
" END IF;"
" RETURN (FIN_YEAR);"
"END;"
IMP-00015: following statement failed because the object already exists:
"CREATE function nums(a in number,b in number,c in number,d in number) retur"
"n number is"
"begin"
"return(a+b+c+d);"
"end;"
IMP-00015: following statement failed because the object already exists:
"CREATE FUNCTION GET_PART(VOU_DATE DATE) RETURN CHAR IS"
"BEGIN"
" IF VOU_DATE >= TO_DATE('1-'||TO_CHAR(VOU_DATE,'MON-YYYY'),'DD-MON-YYYY') "
" AND VOU_DATE <= TO_DATE('20-'||TO_CHAR(VOU_DATE,'MON-YYYY'),'DD-MON-YYYY'"
") THEN"
" RETURN('I');"
" ELSE"
" RETURN('II');"
" END IF;"
"END;"
IMP-00015: following statement failed because the object already exists:
"CREATE FUNCTION GET_PART_START_DT RETURN DATE IS"
"BEGIN"
" NULL;"
"END;"
Import terminated successfully with warnings.
I didnot write full file text here, only write starting and end. For full description please find it as attachment.
Please sort out my problem.
Waiting for reply.
Radha Sharma
-
Attachment: ABC.LOG
(Size: 44.07KB, Downloaded 1307 times)
|
|
|
|
|
Goto Forum:
Current Time: Sat Sep 07 05:51:43 CDT 2024
|