met malam kawan2 senior di indo oracle.
saya menggunakan db oracle 9i dg os unix v.11.kemarin export db
(dump file) dg os windows xp.dan di komp dg os windows xp tsb saya
import (dump file). namun ada beberapa message dalam file export.log
dan import.log.sebagai referensi sbb:
1. export.bat
set ORACLE_SID=PROD
set NLS_LANG=american_america.WE8ISO8859P1
exp system/[EMAIL PROTECTED] parfile=export.txt
2.export.txt
FILE=E:\Dump\Export1.dump,E:\Dump\Export2.dump,E:\Dump\Export3.dump,
E:\Dump\Export4.dump,E:\Dump\Export5.dump,E:\Dump\Export6.dump,
E:\Dump\Export7.dump,E:\Dump\Export8.dump
FILESIZE=2048m
log=E:\Dump\Export.log
buffer=100000
full=y
grants=y
rows=y
indexes=y
3. export.log
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit
Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data
Mining options
JServer Release 9.2.0.1.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR
character set
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table AQ$_INTERNET_AGENTS 0 rows
exported
. . exporting table AQ$_INTERNET_AGENT_PRIVS 0 rows
exported
...
. exporting synonyms
. exporting views
. exporting referential integrity constraints
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting triggers
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully without warnings.
4. import.bat
set ORACLE_SID=DBTEST
imp system/[EMAIL PROTECTED] parfile=import.txt
5. import.txt
FILE=e:\dump\Export1.dump,e:\dump\Export2.dump,e:\dump\Export3.dump,
e:\dump\Export4.dump,e:\dump\Export5.dump,e:\dump\Export6.dump,
e:\dump\Export7.dump,e:\dump\Export8.dump
log=e:\dump\import.log
grants=y
rows=y
filesize=2048m
fromuser=owner
6. 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
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR
character set
export client uses WE8ISO8859P1 character set (possible charset
conversion)
. importing IFSAPP's objects into IFSAPP
. . importing table "ABC_CLASS_TAB" 3 rows
imported
. . importing table "ABSENCE_DEDUCTION_RULE_TAB" 6 rows
imported
...
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'FND_NORMAL' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT EXECUTE ON "AGENDA_API" TO "EIS_ROLE""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'EIS_ROLE' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT EXECUTE ON "FND_SESSION_RPI" TO "EIS_ROLE""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'EIS_ROLE' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT EXECUTE ON "MODULE_RPI" TO "EIS_ROLE""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'EIS_ROLE' does not exist
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE INDEX "WORK_TIME_COUNTER_DESC_3_IX"
ON "WORK_TIME_COUNTER_DESC_TAB" "
"("END_TIME" , "START_TIME" DESC , "CALENDAR_ID" ) PCTFREE 10
INITRANS 2 MA"
"XTRANS 255 STORAGE(INITIAL 73728 FREELISTS 1 FREELIST GROUPS 1)
TABLESPACE "
""FND_DATA" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace
FND_DATA
About to enable constraints...
Import terminated successfully with warnings.
pertanyaannya sbb:
saya melakukan import db tsb untuk keperluan duplikasi dan test
program di komp yg beda dg os windows xp.
1. apakah sudah benar cara saya export dan import,nohon dikoreksi.
2. apa yg harus saya lakukan dg log tsb diatas,mohon solusinya.
3. bagaiman step by stepnya import yg benar agar sesuai dg kondisi
db orinya.
demikian terima kasih tanggapannya.
siswanto
pemula
