| imp issue (2 threads merged by bb) [message #479864] |
Tue, 19 October 2010 17:05  |
bluzman
Messages: 1
Registered: October 2010
|
Junior Member |
|
|
Hi,
I just started to work with Oracle this week; any pointer is greatly appreciated.
I issued the command below and it seen to go through without any warning that I should worry about but it did not create table nor load any data.
imp trrc/trrc file=rrcdw_pdq_clnr_1.dmp fromuser=OVIEDOE touser=trrc log=trrcdata.log
Again, folks, thanks for any pointer.
Cheers,
Bluzman
Out put of trrcdata.log:
hous0204% more trrcdata.log
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
Warning: the objects were exported by OVIEDOE, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
export client uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00046: using FILESIZE value from export file of 2147483648
IMP-00002: failed to open expdat.dmp for read
Import terminated successfully with warnings.
Screen output:
hous0204% imp trrc/trrc file=rrcdw_pdq_clnr_1.dmp fromuser=OVIEDOE touser=trrc log=trrcdata.log
Import: Release 9.2.0.8.0 - Production on Tue Oct 19 15:12:52 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
Warning: the objects were exported by OVIEDOE, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
export client uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00046: using FILESIZE value from export file of 2147483648
Import file: expdat.dmp >
IMP-00002: failed to open expdat.dmp for read
Import file: expdat.dmp > rrcdw_pdq_clnr_2.dmp
Enter name of the next file in the export file set.
Import file: expdat.dmp > rrcdw_pdq_clnr_3.dmp
Enter name of the next file in the export file set.
Import file: expdat.dmp > rrcdw_pdq_clnr_4.dmp
Enter name of the next file in the export file set.
Import file: expdat.dmp > rrcdw_pdq_clnr_5.dmp
Enter name of the next file in the export file set.
Import file: expdat.dmp > rrcdw_pdq_clnr_6.dmp
Enter name of the next file in the export file set.
Import file: expdat.dmp > rrcdw_pdq_clnr_7.dmp
Enter name of the next file in the export file set.
Import file: expdat.dmp > rrcdw_pdq_clnr_8.dmp
Enter name of the next file in the export file set.
Import file: expdat.dmp > rrcdw_pdq_clnr_9.dmp
Enter name of the next file in the export file set.
Import file: expdat.dmp > rrcdw_pdq_clnr_10.dmp
Import terminated successfully with warnings.
Output of checking tablespace ... Nothing was loaded to the trrcdata tablespace
TABLESPACE_NAME BYTES_USED BYTES_FREE LARGEST PERCENT_USED
------------------------------ ---------- ---------- ---------- ------------
USERS 524288000 514719744 514719744 1.83
SYSTEM 1.2695E+10 1.2495E+10 3891265536 1.58
UNDOTS 5242880000 5229576192 3988783104 .25
TRRCDATA 2.3069E+10 2.3069E+10 4160749568 0
[Updated on: Wed, 20 October 2010 08:01] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
