Home » RDBMS Server » Server Utilities » Will Import (Oracle
Will Import [message #432161] Sun, 22 November 2009 08:16 Go to next message
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
Messages: 21146
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
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 Aug 17 16:37:00 CDT 2017

Total time taken to generate the page: 0.10203 seconds