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)
Click Here to Expand Forum to Full Width