Re: Import data without system user.

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 16 Mar 2002 00:38:37 -0800
Message-ID: <a8aed4.0203160038.63d6f569@posting.google.com>

poitrasg_at_crcsogema.com (Gaetan Poitras) wrote in message news:<3ebc2be2.0203141239.29b2571c_at_posting.google.com>...
> I have installed a new database and now I want to do a full import of
> my previous database.
> I want to do the full import because I want the tablespace create
> automaticaly and every schema create without having to create them
> manual first.
>
> The problem is each time we do an full import it import the system
> user and I am afraid to import the system user over my current system
> user. This is probably a wrong way.
> So how can I import a full database exported file without the system
> user.?

What you can do is to use a User Wise export of all the users in the database except the system user.

This will effectively give you a Full Database Backup leaving out sys and system.

HTH Regards,
Ganesh R Received on Sat Mar 16 2002 - 02:38:37 CST