RE: copying all schemas except sys

2002-09-20 Thread Ben
Hi Well my import choked on the package SYS.DBMS_REPCAT_UTL so I assumed that there was SYS stuff in the full export. -Original Message- Gopalakrishnan Sent: September 19, 2002 3:43 PM To: Multiple recipients of list ORACLE-L Export program **never** exports the contents of SYS.

RE: copying all schemas except sys

2002-09-20 Thread Ben
Hi Well my import choked on SYS.DBMS_REPCAT_UTL so I just assumed that there was SYS schema stuff in the full export. I see now that the import must execute this package. This package was having a problem with the fact that the exported global name did not match that of the instance I was

RE: copying all schemas except sys

2002-09-20 Thread Reginald . W . Bailey
Try setting the GLOBAL_NAMES parameter in the init.ora file to FALSE for the target database. RWB Ben [EMAIL PROTECTED]@fatcity.com on 09/20/2002 01:21:34 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

re: copying all schemas except sys

2002-09-19 Thread Ben
Maybe I answered my own question. If I do the full export as another dba user (not sys,system) then hopefully I will not get the sys schema in the export. Ben -Original Message- Sent: September 19, 2002 2:14 PM To: Oracle List New Hi Starting with Oracle8i there is a problem with

RE: copying all schemas except sys

2002-09-19 Thread K Gopalakrishnan
Export program **never** exports the contents of SYS. WHy do you need a parameter IGNORE_SYS when it is ignored already? KG -Original Message- Sent: Thursday, September 19, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Hi Starting with Oracle8i there is a problem with

RE: copying all schemas except sys

2002-09-19 Thread MacGregor, Ian A.
True, and if the original poster will check i believe he'll find those objects are not owned by sys but by system. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 19, 2002 12:43 PM To: Multiple recipients of list ORACLE-L