Oracle Database migration

Udisk database migration
1. Create the tablespace used by udisk users
-- Create user tablespace
Create tablespace udisk datafile 'e: \ oracle92 \ oradata \ udisk. dbf'size 100 m
Uniform size 10 m;

2. Create a udisk user and set the initialization password to udisk.
-- Create user udisk
Create user udisk identified by udisk
Default tablespace udisk
Temporary tablespace temp;

3. Grant various permissions to udisk users

-- Assign connect privilege to user udisk
Grant connect to udisk;
Grant create table to udisk;
Grant unlimited tablespace to udisk;
Grant exp_full_database to udisk;
Grant imp_full_database to udisk;
Grant DBA to udisk;
Grant create procedure to udisk;

4. Export script commands by user
Exp udisk/udisk @ udisk file = D: \ udisk. dmp owner = udisk direct = y log = udisk. Log

5. Import script commands by user
IMP udisk/udisk @ udisk file = D: \ udisk. dmp fromuser = udisk touser = udisk