| Export terminated successfully without warnings. [message #73637] |
Wed, 09 June 2004 07:48  |
Raquel
Messages: 46
Registered: July 2003
|
Member |
|
|
I typed this code in the command prompt:
exp userid=IMAP_snapshot/password@pebbles file=\156.80.190.184trfIMAP_snapshot.dmp log=\156.80.190.184trfIMAP_snapshot.log
and the lines below ran. Does this mean that the tables were exported. The last sentence seems to indicate that the export wasn't successful. There is a IMAP_snapshot.dmp in the directory specified. Did I type something incorrectly in the command prompt? Please HELP!
Connected to: Oracle8i Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TAT_SNAPSHOT
. exporting object type definitions for user TAT_SNAPSHOT
About to export TAT_SNAPSHOT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TAT_SNAPSHOT's tables via Conventional Path ...
. . exporting table DELETED_CLLI_LLZERO 78 rows exported
. . exporting table DELETED_CLLI_PH 54 rows exported
. . exporting table DELETED_LINKS_LLZERO 990 rows exported
. . exporting table DELETED_LINKS_PH 0 rows exported
. . exporting table DELETED_NPA_NXX_LLZERO 224 rows exported
. . exporting table DELETED_NPA_NXX_PH 2232 rows exported
. . exporting table LERG 42977 rows exported
. . exporting table LINKS 69265 rows exported
. . exporting table NPA_NXX 152502 rows exported
. . exporting table STATES 90 rows exported
. . exporting table TYPE_CODES 9 rows exported
. . exporting table UNIQUE_CITIES 22649 rows exported
. . exporting table UNIQUE_LATAS 333 rows exported
. . exporting table UNIQUE_NPAS 322 rows exported
. . exporting table UNIQUE_OCNS 4623 rows exported
. . exporting table UNIQUE_SWITCH_MODEL 199 rows exported
. . exporting table ZEOTABLE 19787 rows exported
. . exporting table ZEOTOSTPTABLE 21691 rows exported
. . exporting table ZEOTOTDMTABLE 22051 rows exported
. . exporting table ZMSCTOEOTABLE 26 rows exported
. . exporting table ZMSCTOTDMTABLE 8002 rows exported
. . exporting table ZOSTDMTABLE 220 rows exported
. . exporting table ZREMTABLE 16030 rows exported
. . exporting table ZREMTOEOTABLE 15624 rows exported
. . exporting table ZSTPTABLE 413 rows exported
. . exporting table ZTDMTABLE 3010 rows exported
. . exporting table ZTDMTOSTPTABLE 3436 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting snapshots
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
|
|
|
|
| Re: Export terminated successfully without warnings. [message #73644 is a reply to message #73637] |
Thu, 10 June 2004 02:12  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Raquel,
How did you decide that Export did not complete properly.
The last line says
"Export terminated successfully without warnings."
This means that Export was succesful.
In Export & Import there are things call Warnings, based upon the severity Export/Import aborts or contnues after logging Warning messages in the Log file.
HTH
Regards
Himanshu
|
|
|
|
| Re: Export terminated successfully without warnings. [message #74156 is a reply to message #73644] |
Tue, 21 September 2004 19:20 |
BHARGAV
Messages: 5
Registered: September 2004
|
Junior Member |
|
|
Hello Himanshu and Raquel,
While Using exp73 with Oracle 7.3, i get the prompt
2 users,3 tables , for i am providing full=yes.
Can u tell how to confirm the default value 2 for
this, so that the user is not prompted?
I export and backup for the user using a batch file.
Thanks in advance.
Bhargav
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
