Re: Full export - import database

Most likely you overlooked the following (as most people do).

In a full export the schema SYS is not exported. For the simple reason that this contains the administration of the database which is of course database specific.

Everything you did in the SYS schema in the origin database must be done again in the destination.
Most people don't create anything in the SYS schema following the advice of Oracle (just for this reason)
But for one thing you can't avoid it: grants select on SYS owner views and grant execute privilege on packages of SYS used or called by your own packages/procedures. Otherwise they won't compile. Privs given via roles won't work in stored packages/procedures.

So check in your origin database what grants SYS has given to others (except to roles, public, other standard oracle schemas) and re-grant them in you destination.

Vince <uv_ss_2001_at_hotmail.com> schreef in berichtnieuws 4a933b77.0204180757.4bda9333_at_posting.google.com...
> Hi Gurus,
>
> I am newbie to oracle.. not to database or administration..
>
> I am trying to move a Oracle 8.1.7 database using export/import to
> another server.
>
> Source Server : HP-UX 11- Oracle 8.1.7.
>
> Destination Server : Sun Solaris 8 - Oracle 8.1.7.
>
> I did the following to create the instance.
>
> Installed Oracle 8.1.7 software on the dest. server.
> copied init.ora, create database, create tablespace scripts
> from soure to destination
> created the instance, tablespaces, rollback segments on the dest.
> server.
> created catalog packages on the dest. server.
> So far no prblem..
> I imported the instance on the dest. server,
> While the import is success with some warnings
>
> Now my questing is
>
> Why there are errors when i do a full import from a full export? am
> i missing any step?
>
> Also i found no of invalid objects in the new imported instance,
> which are not there in the source ? When i recompile all of them
> compiled except for two
> which had previlage peoblems for DBMS_PIPE and DBMS_SYS_SQL. I have
> sort these out.
>
> I had some invalid object in the source, which are valid in
> destination.. What could be the reason..
>
> TIA,
>
> Venkat
Received on Fri Apr 19 2002 - 06:07:31 CDT