I have a 7.3.4 database with numerous schemas and users that I now need to import into an existing 8.1.7 database (there are no schemas/users in the 8.1.7 database with the same name as those in the 7.3.4 database).
To do this I intend to do the following
1. full exp of the 7.3.4 database
2. create schema owners/users in 8.1.7 database
3. grant privs to schema owners/users
4. import each schema by use of
$imp system/password file=exp_file.dmp log=file.log fromuser=user1 touser=user1
Is there anyway to make the creation of users and granting of privs any easier/quicker as this way seems somewhat longwinded?
use the parfile on your import
if it's empty why you dont use FULL=y?
sorry didnt make it clear - the 8.1.5 database is not empty - does hold various schemas (but the schema names do not clash with the ones in the 7.3.4 database so this won't be an issue)