| Tables moved using export and import [message #511039] |
Thu, 09 June 2011 03:36  |
Database admin
Messages: 365
Registered: September 2006
Location: india
|
Senior Member |
 
|
|
Hi ,
I was told to move 8 tables along with constraints,indexes,grants,rows,
triggers from one database to another database.
I did export and import for that.
The command i used was
exp p5/chevuri@db3.SBC.COM file=C:\balaexp.dmp log=C:\balaexp.log
tables= ('tab1','tab2','tab3','tab4','tab5','tab6','tab7') rows=y indexes=y grants=y
constraints=y triggers=y direct=y
Below is the export output log.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 -
64bit Production With the Partitioning, OLAP, Data Mining and Real
Application Testing options Export done in WE8MSWIN1252 character set
and AL16UTF16 NCHAR
character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export specified tables via Direct Path ...
. . exporting table tab1 12 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table tab2 2591 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table tab3 36 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table tab4 1296 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table tab5 36 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table tab6 36 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table tab7 36 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
*imp p10/debroy@db2.SBC.COM fromuser=p5 touser=p10 file=C:\balaexp.dmp
log=C:\balaoutput.log rows=y indexes=y grants=y constraints=y ignore=y commit=y
Here is the import output log
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V10.02.01 via direct path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing JAM's objects into JAM
. . importing table "tab1" 12 rows imported
. . importing table "tab2" 2591 rows imported
. . importing table "tab3" 36 rows imported
. . importing table "tab4" 1296 rows imported
. . importing table "tab5" 36 rows imported
. . importing table "tab6" 36 rows imported
. . importing table "tab7" 36 rows imported
About to enable constraints...
Import terminated successfully without warnings.
Everything got imported successfully . Still i have a doubt in export
and import command, whether the command that i used for export
and import was correct or if there is anything need to be added in command.
Thanks
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
