Home » RDBMS Server » Server Utilities » Tables moved using export and import (Oracle 10.2.0.2.0,Unix)
Tables moved using export and import [message #511039] Thu, 09 June 2011 03:36 Go to next message
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



Re: Tables moved using export and import [message #511042 is a reply to message #511039] Thu, 09 June 2011 03:46 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The warnings in export just mean that the statistics that are exported may not be up to date.
I advise you to always export without statistics and import it as well and gather statistics after this later one.

Regards
Michel
Re: Tables moved using export and import [message #511055 is a reply to message #511042] Thu, 09 June 2011 04:49 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Thanks for your wonderful explanation.I learned something new today.

So in order to export without statistics i need to use statistics= NONE in export .

Am i correct ?


Thanks
Re: Tables moved using export and import [message #511058 is a reply to message #511055] Thu, 09 June 2011 05:07 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Re: Tables moved using export and import [message #511074 is a reply to message #511058] Thu, 09 June 2011 07:49 Go to previous message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member



Thanks Michel Smile
Previous Topic: Porting data from text file
Next Topic: character set erro while importing.
Goto Forum:
  


Current Time: Tue Sep 02 05:00:10 CDT 2014

Total time taken to generate the page: 0.29660 seconds