ptreves
asked on
Unknown User Alcie: ORA-01435
Hello,
I am trying to import a DB into Oracle 9i, using hte Import Utility I ran into the following PBs:
[oracle@Linux2005 oracle]$ imp system/tiger FILE=/OraHome/080904.dmp FROMUSER=AL CIE FULL IGNORE=N
Import: Release 9.2.0.4.0 - Production on Thu Sep 9 19:47:11 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
Export file created by EXPORT:V08.01.05 via conventional path
Warning: the objects were exported by ALCIE, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export client uses WE8ISO8859P1 character set (possible charset conversion)
export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversio n)
. importing ALCIE's objects into ALCIE
"ALTER SESSION SET CURRENT_SCHEMA= "ALCIE""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully
[oracle@Linux2005 oracle]
====
I guess that I have to precreate an ALCIE user and then attempt another import ?
Should I jsut create a new virgin DB ?
PT
I am trying to import a DB into Oracle 9i, using hte Import Utility I ran into the following PBs:
[oracle@Linux2005 oracle]$ imp system/tiger FILE=/OraHome/080904.dmp FROMUSER=AL CIE FULL IGNORE=N
Import: Release 9.2.0.4.0 - Production on Thu Sep 9 19:47:11 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
Export file created by EXPORT:V08.01.05 via conventional path
Warning: the objects were exported by ALCIE, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export client uses WE8ISO8859P1 character set (possible charset conversion)
export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversio n)
. importing ALCIE's objects into ALCIE
"ALTER SESSION SET CURRENT_SCHEMA= "ALCIE""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully
[oracle@Linux2005 oracle]
====
I guess that I have to precreate an ALCIE user and then attempt another import ?
Should I jsut create a new virgin DB ?
PT
there are three modes of import
one is FULL=Y
second is FROMUSER=ALCIE but you have to pair it up with TOUSER=ALCIE
third is TABLES=(tab1, tab2...tabn)
one is FULL=Y
second is FROMUSER=ALCIE but you have to pair it up with TOUSER=ALCIE
third is TABLES=(tab1, tab2...tabn)
ASKER
Hello again,
Following your recommendations, I got the following output after performing a new DB import;
-----
[oracle@Linux2005 OraHome]$ imp system/manager FILE=/OraHome/080904.dmp FROMUSER=ALCIE TOUSER=ALCIE IGNORE=Y
Import: Release 9.2.0.4.0 - Production on Fri Sep 10 11:01:45 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
Export file created by EXPORT:V08.01.05 via conventional path
Warning: the objects were exported by ALCIE, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export client uses WE8ISO8859P1 character set (possible charset conversion)
export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)
. importing ALCIE's objects into ALCIE
. . importing table "ACCESSIBLE_PRINTERS" 1 rows imported
. . importing table "APCOMVEN" 0 rows imported
. . importing table "APCTL" 0 rows imported
. . importing table "APDETAIL" 0 rows imported
. . importing table "APMASTER" 0 rows imported
. . importing table "APSUBSRC" 0 rows imported
. . importing table "APTRXHDR" 0 rows imported
. . importing table "APTRXLIN" 0 rows imported
. . importing table "ARAVGDAY" 511 rows imported
. . importing table "ARCASH" 0 rows imported
. . importing table "ARCCODE" 0 rows imported
. . importing table "ARCNTLVL" 0 rows imported
. . importing table "ARCOMCUS" 1 rows imported
. . importing table "ARCOMPCT" 0 rows imported
. . importing table "ARCTL" 1 rows imported
. . importing table "ARCUSCDE" 0 rows imported
. . importing table "ARCUSTYPE" 3 rows imported
. . importing table "ARDETAIL" 16902 rows imported
. . importing table "ARFINCHG" 0 rows imported
. . importing table "ARFINCTL" 1 rows imported
. . importing table "ARFREQ" 2 rows imported
. . importing table "ARGRPTYPE" 0 rows imported
. . importing table "ARINVHEADER" 0 rows imported
. . importing table "ARINVLINE" 0 rows imported
. . importing table "ARITEM" 0 rows imported
. . importing table "ARITEMCMTS" 0 rows imported
. . importing table "ARMASTER" 3306 rows imported
. . importing table "ARRECCDE" 0 rows imported
. . importing table "ARRECCHG" 0 rows imported
. . importing table "ARRECCTL" 0 rows imported
. . importing table "ARREVAL" 0 rows imported
. . importing table "ARSALESHDR" 7 rows imported
. . importing table "ARSALESLIN" 3 rows imported
. . importing table "ARSHIPTO" 8 rows imported
. . importing table "ARSLSMAN" 0 rows imported
. . importing table "ARSUBSRC" 1 rows imported
. . importing table "ARSUMBAL" 1400 rows imported
. . importing table "ARSUMBAL01" 26 rows imported
. . importing table "ARSVCCHG" 0 rows imported
. . importing table "ARTITLES" 0 rows imported
. . importing table "ARTRXDST" 47285 rows imported
. . importing table "ARTRXINP" 13 rows imported
. . importing table "ARTYPE" 8 rows imported
. . importing table "AR_HIST" 0 rows imported
. . importing table "BKSUBSRC" 1 rows imported
. . importing table "BONUS" 0 rows imported
. . importing table "CADASTRE" 1361 rows imported
. . importing table "CALENDAR" 31 rows imported
. . importing table "CHECKREC" 0 rows imported
. . importing table "COMPANY" 2 rows imported
. . importing table "COPIES_SENT" 5370 rows imported
. . importing table "CUSTOMER" 27 rows imported
. . importing table "DEFAULT_PRINTERS" 0 rows imported
. . importing table "DEPT" 4 rows imported
. . importing table "DUMMY" 1 rows imported
. . importing table "EMP" 14 rows imported
. . importing table "EXP_PLAN" 4 rows imported
. . importing table "FOB" 0 rows imported
. . importing table "FOREXC" 0 rows imported
. . importing table "FREIGHT" 0 rows imported
. . importing table "GEN" 49 rows imported
. . importing table "GENLABEL" 0 rows imported
. . importing table "GLACTCDE" 12 rows imported
. . importing table "GLBATCH" 0 rows imported
. . importing table "GLCHART" 17 rows imported
. . importing table "GLCOMCHT" 1 rows imported
. . importing table "GLDEPT" 0 rows imported
. . importing table "GLDIV" 0 rows imported
. . importing table "GLPERIOD" 12 rows imported
. . importing table "GLSUMBAL" 55 rows imported
. . importing table "GLTRANS" 80 rows imported
. . importing table "GLTRXCTL" 0 rows imported
. . importing table "HBJOBBOM" 0 rows imported
. . importing table "HBJOBMSTR" 0 rows imported
. . importing table "HBPROJ" 0 rows imported
. . importing table "IMCOMITM" 0 rows imported
. . importing table "IMCTL" 0 rows imported
. . importing table "IMITEMLOC" 0 rows imported
. . importing table "IMMASTER" 0 rows imported
. . importing table "IMSTKLOC" 0 rows imported
. . importing table "INTEGERS" 402 rows imported
. . importing table "INTERCO" 0 rows imported
. . importing table "ITEM" 64 rows imported
. . importing table "LOOKUP" 1001 rows imported
. . importing table "LOT" 493848 rows imported
. . importing table "MAILING_LABEL" 1 rows imported
. . importing table "MENU_B_APPL" 0 rows imported
. . importing table "MENU_B_APPL_GRP" 0 rows imported
. . importing table "MENU_B_INFO" 0 rows imported
. . importing table "MENU_B_OPTION" 0 rows imported
. . importing table "MENU_B_PARAM" 0 rows imported
. . importing table "MENU_B_PARM_XREF" 0 rows imported
. . importing table "MESSAGE" 5 rows imported
. . importing table "MODULE_TABLES" 1282 rows imported
. . importing table "MUNICIPALITY" 144 rows imported
. . importing table "NAMES" 27 rows imported
. . importing table "NEEDED_INFO" 11 rows imported
. . importing table "NEEDED_INFO_FORM" 433 rows imported
. . importing table "NUMEROLOGY" 20 rows imported
. . importing table "OECOMPDE" 0 rows imported
. . importing table "OECTL" 0 rows imported
. . importing table "OEHEADER" 0 rows imported
. . importing table "OELINE" 0 rows imported
. . importing table "OEPRICE_LEVEL" 0 rows imported
. . importing table "ORD" 21 rows imported
. . importing table "PAYTERMS" 0 rows imported
. . importing table "PLAN_TABLE" 2 rows imported
. . importing table "POLINE" 0 rows imported
. . importing table "PRACCRUE" 0 rows imported
. . importing table "PRGRADE" 0 rows imported
. . importing table "PRHISTORY" 0 rows imported
. . importing table "PRICE" 17 rows imported
. . importing table "PRINT_INV" 947 rows imported
. . importing table "PRMASTER" 0 rows imported
. . importing table "PRODCAT" 0 rows imported
. . importing table "PRODUCT" 10 rows imported
. . importing table "PRODUCT_ACCESS" 0 rows imported
. . importing table "PRODUCT_PROFILE" 1 rows imported
. . importing table "PROJECT_NEEDED_INFO" 1397 rows imported
. . importing table "PRPOSITION" 0 rows imported
. . importing table "PRSHIFT" 0 rows imported
. . importing table "REGION" 0 rows imported
. . importing table "REGISTRY_OFFICE" 11 rows imported
. . importing table "RENOVATION" 30856 rows imported
. . importing table "SALGRADE" 5 rows imported
. . importing table "SHIPVIA" 4 rows imported
. . importing table "STATECODES" 0 rows imported
. . importing table "STDTEST" 0 rows imported
. . importing table "SURVEYOR" 43 rows imported
. . importing table "SURVEYOR_MAX" 83 rows imported
. . importing table "SYBKRECTMP" 0 rows imported
. . importing table "SYCRATES" 0 rows imported
. . importing table "SYMENU_APPLICATION" 3 rows imported
. . importing table "SYMENU_CTL" 2 rows imported
. . importing table "SYMENU_HELP" 0 rows imported
. . importing table "SYMENU_INFO" 43 rows imported
. . importing table "SYMENU_OPTION" 341 rows imported
. . importing table "SYMENU_OPTION_ORIG" 225 rows imported
. . importing table "SYMENU_USER" 3 rows imported
. . importing table "SYMENU_WORKCLASS" 5 rows imported
. . importing table "SYREGISTER" 0 rows imported
. . importing table "SYREVRATE" 0 rows imported
. . importing table "TAXENTITY" 2 rows imported
. . importing table "TBBILL" 9205 rows imported
. . importing table "TBBUDGET" 5644 rows imported
. . importing table "TBBURDEN" 17 rows imported
. . importing table "TBCLIENT" 0 rows imported
. . importing table "TBCLSPRJ" 0 rows imported
. . importing table "TBCOSBIL" 0 rows imported
. . importing table "TBCTL" 1 rows imported
. . importing table "TBDETAIL" 299 rows imported
. . importing table "TBDOCTRACK" 960 rows imported
. . importing table "TBDOCTRACK2" 700 rows imported
. . importing table "TBEMPLOYEE" 23 rows imported
. . importing table "TBFIELD" 2010 rows imported
. . importing table "TBINV_COMMENTS" 1 rows imported
. . importing table "TBLINEDES" 470 rows imported
. . importing table "TBLOTRELATION" 3254 rows imported
. . importing table "TBLRATE" 0 rows imported
. . importing table "TBOFFICE" 9 rows imported
. . importing table "TBOLDNEWLOT" 791 rows imported
. . importing table "TBPARRPT" 0 rows imported
. . importing table "TBPERIOD" 124 rows imported
. . importing table "TBPRJSTATUS" 6 rows imported
. . importing table "TBPRJTYP" 11 rows imported
. . importing table "TBPROJECT" 35939 rows imported
. . importing table "TBPROJ_TEMP" 28011 rows imported
. . importing table "TBRATECODE" 3 rows imported
. . importing table "TBRATES" 16 rows imported
. . importing table "TBSEL" 1 rows imported
. . importing table "TBSTCOPY" 0 rows imported
. . importing table "TBSTWKHR" 9 rows imported
. . importing table "TBTEMPGL" 0 rows imported
. . importing table "TBTRXINP" 84772 rows imported
. . importing table "TBUNITPRICE" 49 rows imported
. . importing table "TBWRKCAT" 71 rows imported
. . importing table "TBWRKCDE" 674 rows imported
. . importing table "TEMPSALES" 0 rows imported
. . importing table "TEMP_BCT_CLOSE" 0 rows imported
. . importing table "TERMS" 2 rows imported
. . importing table "TERRITORY" 0 rows imported
. . importing table "TRANSMITTAL_FORM" 1560 rows imported
. . importing table "UNIT_COST_GENERAL_RATE" 0 rows imported
. . importing table "UOMCONV" 0 rows imported
. . importing table "USERACCESS" 1 rows imported
. . importing table "USERCO" 2 rows imported
. . importing table "USER_PRINTER" 0 rows imported
. . importing table "USER_PRINT_CONTROL" 0 rows imported
. . importing table "USER_PROFILE" 0 rows imported
. . importing table "ZONE" 0 rows imported
Import terminated successfully without warnings.
[oracle@Linux2005 OraHome]$
=====
Why are some tables, no rows imported ?
Does this meed my DB has been successfully imported from Oracle 8i to 9i ?
Is something still missing ? What should I look for ?
PT
Following your recommendations, I got the following output after performing a new DB import;
-----
[oracle@Linux2005 OraHome]$ imp system/manager FILE=/OraHome/080904.dmp FROMUSER=ALCIE TOUSER=ALCIE IGNORE=Y
Import: Release 9.2.0.4.0 - Production on Fri Sep 10 11:01:45 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
Export file created by EXPORT:V08.01.05 via conventional path
Warning: the objects were exported by ALCIE, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export client uses WE8ISO8859P1 character set (possible charset conversion)
export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)
. importing ALCIE's objects into ALCIE
. . importing table "ACCESSIBLE_PRINTERS" 1 rows imported
. . importing table "APCOMVEN" 0 rows imported
. . importing table "APCTL" 0 rows imported
. . importing table "APDETAIL" 0 rows imported
. . importing table "APMASTER" 0 rows imported
. . importing table "APSUBSRC" 0 rows imported
. . importing table "APTRXHDR" 0 rows imported
. . importing table "APTRXLIN" 0 rows imported
. . importing table "ARAVGDAY" 511 rows imported
. . importing table "ARCASH" 0 rows imported
. . importing table "ARCCODE" 0 rows imported
. . importing table "ARCNTLVL" 0 rows imported
. . importing table "ARCOMCUS" 1 rows imported
. . importing table "ARCOMPCT" 0 rows imported
. . importing table "ARCTL" 1 rows imported
. . importing table "ARCUSCDE" 0 rows imported
. . importing table "ARCUSTYPE" 3 rows imported
. . importing table "ARDETAIL" 16902 rows imported
. . importing table "ARFINCHG" 0 rows imported
. . importing table "ARFINCTL" 1 rows imported
. . importing table "ARFREQ" 2 rows imported
. . importing table "ARGRPTYPE" 0 rows imported
. . importing table "ARINVHEADER" 0 rows imported
. . importing table "ARINVLINE" 0 rows imported
. . importing table "ARITEM" 0 rows imported
. . importing table "ARITEMCMTS" 0 rows imported
. . importing table "ARMASTER" 3306 rows imported
. . importing table "ARRECCDE" 0 rows imported
. . importing table "ARRECCHG" 0 rows imported
. . importing table "ARRECCTL" 0 rows imported
. . importing table "ARREVAL" 0 rows imported
. . importing table "ARSALESHDR" 7 rows imported
. . importing table "ARSALESLIN" 3 rows imported
. . importing table "ARSHIPTO" 8 rows imported
. . importing table "ARSLSMAN" 0 rows imported
. . importing table "ARSUBSRC" 1 rows imported
. . importing table "ARSUMBAL" 1400 rows imported
. . importing table "ARSUMBAL01" 26 rows imported
. . importing table "ARSVCCHG" 0 rows imported
. . importing table "ARTITLES" 0 rows imported
. . importing table "ARTRXDST" 47285 rows imported
. . importing table "ARTRXINP" 13 rows imported
. . importing table "ARTYPE" 8 rows imported
. . importing table "AR_HIST" 0 rows imported
. . importing table "BKSUBSRC" 1 rows imported
. . importing table "BONUS" 0 rows imported
. . importing table "CADASTRE" 1361 rows imported
. . importing table "CALENDAR" 31 rows imported
. . importing table "CHECKREC" 0 rows imported
. . importing table "COMPANY" 2 rows imported
. . importing table "COPIES_SENT" 5370 rows imported
. . importing table "CUSTOMER" 27 rows imported
. . importing table "DEFAULT_PRINTERS" 0 rows imported
. . importing table "DEPT" 4 rows imported
. . importing table "DUMMY" 1 rows imported
. . importing table "EMP" 14 rows imported
. . importing table "EXP_PLAN" 4 rows imported
. . importing table "FOB" 0 rows imported
. . importing table "FOREXC" 0 rows imported
. . importing table "FREIGHT" 0 rows imported
. . importing table "GEN" 49 rows imported
. . importing table "GENLABEL" 0 rows imported
. . importing table "GLACTCDE" 12 rows imported
. . importing table "GLBATCH" 0 rows imported
. . importing table "GLCHART" 17 rows imported
. . importing table "GLCOMCHT" 1 rows imported
. . importing table "GLDEPT" 0 rows imported
. . importing table "GLDIV" 0 rows imported
. . importing table "GLPERIOD" 12 rows imported
. . importing table "GLSUMBAL" 55 rows imported
. . importing table "GLTRANS" 80 rows imported
. . importing table "GLTRXCTL" 0 rows imported
. . importing table "HBJOBBOM" 0 rows imported
. . importing table "HBJOBMSTR" 0 rows imported
. . importing table "HBPROJ" 0 rows imported
. . importing table "IMCOMITM" 0 rows imported
. . importing table "IMCTL" 0 rows imported
. . importing table "IMITEMLOC" 0 rows imported
. . importing table "IMMASTER" 0 rows imported
. . importing table "IMSTKLOC" 0 rows imported
. . importing table "INTEGERS" 402 rows imported
. . importing table "INTERCO" 0 rows imported
. . importing table "ITEM" 64 rows imported
. . importing table "LOOKUP" 1001 rows imported
. . importing table "LOT" 493848 rows imported
. . importing table "MAILING_LABEL" 1 rows imported
. . importing table "MENU_B_APPL" 0 rows imported
. . importing table "MENU_B_APPL_GRP" 0 rows imported
. . importing table "MENU_B_INFO" 0 rows imported
. . importing table "MENU_B_OPTION" 0 rows imported
. . importing table "MENU_B_PARAM" 0 rows imported
. . importing table "MENU_B_PARM_XREF" 0 rows imported
. . importing table "MESSAGE" 5 rows imported
. . importing table "MODULE_TABLES" 1282 rows imported
. . importing table "MUNICIPALITY" 144 rows imported
. . importing table "NAMES" 27 rows imported
. . importing table "NEEDED_INFO" 11 rows imported
. . importing table "NEEDED_INFO_FORM" 433 rows imported
. . importing table "NUMEROLOGY" 20 rows imported
. . importing table "OECOMPDE" 0 rows imported
. . importing table "OECTL" 0 rows imported
. . importing table "OEHEADER" 0 rows imported
. . importing table "OELINE" 0 rows imported
. . importing table "OEPRICE_LEVEL" 0 rows imported
. . importing table "ORD" 21 rows imported
. . importing table "PAYTERMS" 0 rows imported
. . importing table "PLAN_TABLE" 2 rows imported
. . importing table "POLINE" 0 rows imported
. . importing table "PRACCRUE" 0 rows imported
. . importing table "PRGRADE" 0 rows imported
. . importing table "PRHISTORY" 0 rows imported
. . importing table "PRICE" 17 rows imported
. . importing table "PRINT_INV" 947 rows imported
. . importing table "PRMASTER" 0 rows imported
. . importing table "PRODCAT" 0 rows imported
. . importing table "PRODUCT" 10 rows imported
. . importing table "PRODUCT_ACCESS" 0 rows imported
. . importing table "PRODUCT_PROFILE" 1 rows imported
. . importing table "PROJECT_NEEDED_INFO" 1397 rows imported
. . importing table "PRPOSITION" 0 rows imported
. . importing table "PRSHIFT" 0 rows imported
. . importing table "REGION" 0 rows imported
. . importing table "REGISTRY_OFFICE" 11 rows imported
. . importing table "RENOVATION" 30856 rows imported
. . importing table "SALGRADE" 5 rows imported
. . importing table "SHIPVIA" 4 rows imported
. . importing table "STATECODES" 0 rows imported
. . importing table "STDTEST" 0 rows imported
. . importing table "SURVEYOR" 43 rows imported
. . importing table "SURVEYOR_MAX" 83 rows imported
. . importing table "SYBKRECTMP" 0 rows imported
. . importing table "SYCRATES" 0 rows imported
. . importing table "SYMENU_APPLICATION" 3 rows imported
. . importing table "SYMENU_CTL" 2 rows imported
. . importing table "SYMENU_HELP" 0 rows imported
. . importing table "SYMENU_INFO" 43 rows imported
. . importing table "SYMENU_OPTION" 341 rows imported
. . importing table "SYMENU_OPTION_ORIG" 225 rows imported
. . importing table "SYMENU_USER" 3 rows imported
. . importing table "SYMENU_WORKCLASS" 5 rows imported
. . importing table "SYREGISTER" 0 rows imported
. . importing table "SYREVRATE" 0 rows imported
. . importing table "TAXENTITY" 2 rows imported
. . importing table "TBBILL" 9205 rows imported
. . importing table "TBBUDGET" 5644 rows imported
. . importing table "TBBURDEN" 17 rows imported
. . importing table "TBCLIENT" 0 rows imported
. . importing table "TBCLSPRJ" 0 rows imported
. . importing table "TBCOSBIL" 0 rows imported
. . importing table "TBCTL" 1 rows imported
. . importing table "TBDETAIL" 299 rows imported
. . importing table "TBDOCTRACK" 960 rows imported
. . importing table "TBDOCTRACK2" 700 rows imported
. . importing table "TBEMPLOYEE" 23 rows imported
. . importing table "TBFIELD" 2010 rows imported
. . importing table "TBINV_COMMENTS" 1 rows imported
. . importing table "TBLINEDES" 470 rows imported
. . importing table "TBLOTRELATION" 3254 rows imported
. . importing table "TBLRATE" 0 rows imported
. . importing table "TBOFFICE" 9 rows imported
. . importing table "TBOLDNEWLOT" 791 rows imported
. . importing table "TBPARRPT" 0 rows imported
. . importing table "TBPERIOD" 124 rows imported
. . importing table "TBPRJSTATUS" 6 rows imported
. . importing table "TBPRJTYP" 11 rows imported
. . importing table "TBPROJECT" 35939 rows imported
. . importing table "TBPROJ_TEMP" 28011 rows imported
. . importing table "TBRATECODE" 3 rows imported
. . importing table "TBRATES" 16 rows imported
. . importing table "TBSEL" 1 rows imported
. . importing table "TBSTCOPY" 0 rows imported
. . importing table "TBSTWKHR" 9 rows imported
. . importing table "TBTEMPGL" 0 rows imported
. . importing table "TBTRXINP" 84772 rows imported
. . importing table "TBUNITPRICE" 49 rows imported
. . importing table "TBWRKCAT" 71 rows imported
. . importing table "TBWRKCDE" 674 rows imported
. . importing table "TEMPSALES" 0 rows imported
. . importing table "TEMP_BCT_CLOSE" 0 rows imported
. . importing table "TERMS" 2 rows imported
. . importing table "TERRITORY" 0 rows imported
. . importing table "TRANSMITTAL_FORM" 1560 rows imported
. . importing table "UNIT_COST_GENERAL_RATE" 0 rows imported
. . importing table "UOMCONV" 0 rows imported
. . importing table "USERACCESS" 1 rows imported
. . importing table "USERCO" 2 rows imported
. . importing table "USER_PRINTER" 0 rows imported
. . importing table "USER_PRINT_CONTROL" 0 rows imported
. . importing table "USER_PROFILE" 0 rows imported
. . importing table "ZONE" 0 rows imported
Import terminated successfully without warnings.
[oracle@Linux2005 OraHome]$
=====
Why are some tables, no rows imported ?
Does this meed my DB has been successfully imported from Oracle 8i to 9i ?
Is something still missing ? What should I look for ?
PT
ASKER
Hello again,
I checked that my users and tablespaces exists and that my import function was successfull.
Why I cannot directly query one of the tables like select * from lot;
WHere lot is an imported table.
What is misisng ?
PT
I checked that my users and tablespaces exists and that my import function was successfull.
Why I cannot directly query one of the tables like select * from lot;
WHere lot is an imported table.
What is misisng ?
PT
Why are some tables, no rows imported ?
Does this meed my DB has been successfully imported from Oracle 8i to 9i ?
Is something still missing ? What should I look for ?
Yes, your import is successful as indicate by this message:
"Import terminated successfully without warnings" at the very end .
some tables just don't have any rows of data that's why no rows imported.
make sure you have the right SELECT permission on the LOT table.
in the worst, 'you can log in as sysdba
SELECT * from <SCHEMA_NAME>.LOT ;
Does this meed my DB has been successfully imported from Oracle 8i to 9i ?
Is something still missing ? What should I look for ?
Yes, your import is successful as indicate by this message:
"Import terminated successfully without warnings" at the very end .
some tables just don't have any rows of data that's why no rows imported.
make sure you have the right SELECT permission on the LOT table.
in the worst, 'you can log in as sysdba
SELECT * from <SCHEMA_NAME>.LOT ;
ASKER
Hello,
What does that mean exactly ?
Lets say LOT belongs to the ALCIEIND tablespace, then I should query:
select * from alcieind.lot;
PT
What is a shema ?
What does that mean exactly ?
Lets say LOT belongs to the ALCIEIND tablespace, then I should query:
select * from alcieind.lot;
PT
What is a shema ?
oh, dude..
ok let's get some basics here...
try to get this:
SQL>select owner, table_name from all_tables where table_name ='LOT';
you can get the Owner of the table "lot"
then try to log in as SYSDBA
SQL>select * from <owner>.LOT;
ok let's get some basics here...
try to get this:
SQL>select owner, table_name from all_tables where table_name ='LOT';
you can get the Owner of the table "lot"
then try to log in as SYSDBA
SQL>select * from <owner>.LOT;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
but your import command is not exactly right , either.
try this:
imp system/tiger FILE=/OraHome/080904.dmp FROMUSER=ALCIE TOUSER=ALCIE IGNORE=Y