• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1089
  • Last Modified:

Is okay to export the SYS or SYSTEM or CTXSYS users and import them?

On an 8i or 8.1.7.4.1 Oracle database
Is it okay to export the users:
SYS or SYSTEM or CTXSYS,
JAVADEBUGPRIV or
JAVAIDPRIV or
JAVASYSPRIV or
JAVAUSERPRIV or
JAVA_ADMIN or
JAVA_DEPLOY
and import them into another database or will this screw up the database e.g
the dbid and sids being wrong etc...
0
Robert Silver
Asked:
Robert Silver
3 Solutions
 
sdstuberCommented:
you shouldn't be able to export sys, system or ctxsys and import them.

but if you could, I wouldn't try.

if you want everything, just do a full db export which won't really grab those schemas even though it's called "full"
and then do a full import into another db,  the dictionary schemas will be populated as you import the other schemas
0
 
Robert SilverAuthor Commented:
I do not wish to export the whole database as one export for several reasons
1. The database is way too big
2. I want more control over the import than that

Can you suggest a way to determine individual schemas and will that be enough
What about the JAVA users? Can I just import them??
0
 
sdstuberCommented:
you can import the java users as those aren't part of the oracle dictionary. those are application schemas
0
 
schwertnerCommented:
You have to export only the nonsystem users.
If you do full export Oracle will not allow you to update the
SYS schema. There will be a lot of error messages in regard of these
objects that normally are simply ignored.

Concentrate on the user that constitutes (build) your application(s).

About Java "users" - they are not users at all, they are roles that are created when you install the Java option on 8i:

In 8.1.5, the security provided you the choice of two secure roles:

JAVAUSERPRIV--few Permissions, including examining properties

JAVASYSPRIV--major Permissions, including updating JVM protected packages

So installing Java on 8i you will get also these roles and all other  objects in the Java stuff.

Good luck!
0
 
FayyazCommented:
My recommendations in this regard are:
Take a full export Dump from source database.
Create a new empty database where you want to import. Create tablespaces and users.
import the dump file user by user using fromuser=<source user>, touser=<target user>.
No need to import SYS, SYSTEM etc. Because when you create a new database sys and system will be there.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now