Mindi,

As regards SYS it shouldn't be a problem, since the SYS schema is not
exported and thus not included in the dump file. SYSTEM schema would be
exported and imported and you may be seeing error messages depending on
whether you have not an object being imported exists or not.

HTH


Thanks
Chandra Pabba

-----Original Message-----
From: mindi
[mailto:oracledba-ezmlmshield-x30321322.[Email address protected]
Sent: Wednesday, April 04, 2007 9:17 AM
To: LazyDBA Discussion
Subject: Full import with ignore=y, impact on SYS/SYSTEM objects


If I run a FULL IMPORT process with ignore=y - will it cause any
problems
for system and sys schemas.

Thanks,
Mindi

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Mindi Gill, Database Administrator
New York Times Company - Shared Services Center
101 West Main St., Suite 7000
World Trade Center - Norfolk, VA 23510

Voice: (757)628-1918 Fax: (757)628-2056
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
"What sunshine is to flowers, smiles are to humanity."
-
Joseph
Addison
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





Oracle LazyDBA home page