Home » RDBMS Server » Server Utilities » Will Import (Oracle 10.2.0.1)
Will Import [message #432161] Sun, 22 November 2009 08:16 Go to next message
zeeshansheikh83@gmail.com
Messages: 3
Registered: October 2009
Location: Kuwait
Junior Member
We want to create a clone database environment with different character Set (We can alter character set as new character set is not super set for old charcater set).

Steps done

1- Export from source database.
2- created same environment and a new database with new character set .
3- import full database in new charcater set

Please suggest while taking full import it imported SYS and SYSTEM objects is this recommended to over write SYS and SYSTEM Schema objects?

Or we should do Schema By Schema Import?
Re: Will Import [message #432220 is a reply to message #432161] Mon, 23 November 2009 01:14 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, Objects nor grants owned by SYS will not be exported (and, consequentially, imported). (Most of) SYSTEM owned objects will already exist in the target database, so you'll get a warning message. Review the import log file, but - those warnings can probably be ignored.
Re: Will Import [message #432694 is a reply to message #432220] Wed, 25 November 2009 15:06 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Also before export/import using CSSCAN utility try to check database character set migration
Previous Topic: EXP/IMP 8.0.5
Next Topic: is it possible to use impdp for a table without using REMAP_TABLESPACE
Goto Forum:
  


Current Time: Thu Sep 29 22:48:02 CDT 2016

Total time taken to generate the page: 0.06390 seconds