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.