hello sir,
my OS is linux.
My oracle version is 10.1.3.0.0
sir during my export operation is got "exp-00091" error.
Connected to: Oracle Database 10g Release 10.1.0.3.0 - Production
**Export done in US7ASCII
character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possiblecharset conversion)**
About to export specified users ...
.
exporting pre-schema procedural objects and actions
.
exporting foreign function library names for user NOMOLIVE
.
exporting PUBLIC type synonyms
.
exporting private type synonyms
.
exporting object type definitions for user NOMOLIVE
About to export NOMOLIVE's objects ...
.
exporting database links
. exporting sequence numbers
.
exporting cluster definitions
. about to export NOMOLIVE's tables via Conventional Path ...
. .
FOR this error sir i am using In my export scritps "statististics = none"
and in my export log file i see below ...
exporting table FH_TDS_USER_SETUP_HST 0 rows exported
. .
exporting table FH_TDS_YEAR_HIST 0 rows exported
. .
exporting table FINAL_OUTPUT
. .
exporting table FIXH_ADJ_REASON_HIST 5 rows exported
. .
exporting table FIXH_ASSET_HIST 145 rows exported
. .
exporting table FW_BUDGET_GROUP_TRANSFER 0 rows exported
. .
exporting table FW_BUDGET_MAIN 0 rows exported
. .
exporting table FW_BUDGET_PERIOD
. .
exporting table FW_BUDGET_SUB_PERIOD
. . exporting table FW_COA_LEVEL_DET 0 rows exported
. .
exporting table FW_FT_TDS_LEDGER 0 rows exported
. .
and end of export file message is display...
**
Export terminated successfully without warnings.
**
Schema name is "nomo" and Total No. of Tables is "2900".
Problem
When i import above file i got another error.
"imp-00041"
and when i query on user_tables or user_segments result is different.
SQL> select count(*) from user_tables;
COUNT(*)
----------
2900
SQL> select count(*) from user_segments where segment_type = 'TABLE';
COUNT(*)
----------
2855
And above 45 tables ( 2900-2855) are not created.
sir what is problem plz. reply
thank you.
sir.
Message was edited by:
user526835
Hello experts Plz reply.