Use SQL Developer to port SQL to Oracle (2)

This article introducesSQL migrationThe second part: create a data file library Migration Repository ).

1. Connect to Oracle

In the connection window on the left of the program, click the plus sign to add oneOracle DatabaseFor example:

After the configuration is complete, click Connect to connect to the database.

2. Create a user

Open the connection to Oracle Data and create a new user. In this mode, we need to create the so-called "Data Archiving database" and use this user to create the user name after SQL Server migration, and other work. According to the instructions in the help, this user requires at least the following permissions and roles:

Roles:Connect with admin option, resource with admin option.

Privileges:Alter any role, alter any sequence, alter any table, alter tablespace, alter any trigger, comment any table, create any sequence, create any table, create any trigger, create view with admin option, create public synonym with admin option, create role, create user, drop any sequence, drop any table, drop any trigger, drop user, drop any role, grant any role, insert any table, select any table, update any table.

The following statement directly creates a user named migrations:

-- Create the user

 
 

  
  
create user MIGRATIONS  
  
  
 
  
  
identified by MIGRATIONS  
  
  
 
  
  
default tablespace USERS  
  
  
 
  
  
temporary tablespace TEMP  
  
  
 
  
  
profile DEFAULT; 
 
 

-- Grant/Revoke role privileges

 
 

  
  
grant connect to MIGRATIONS with admin option;  
  
  
 
  
  
grant resource to MIGRATIONS with admin option; 
 
 

-- Grant/Revoke system privileges

 
 

  
  
grant alter any role to MIGRATIONS;  
  
  
 
  
  
grant alter any sequence to MIGRATIONS;  
  
  
 
  
  
grant alter any table to MIGRATIONS;  
  
  
 
  
  
grant alter any trigger to MIGRATIONS;  
  
  
 
  
  
grant alter tablespace to MIGRATIONS;  
  
  
 
  
  
grant comment any table to MIGRATIONS;  
  
  
 
  
  
grant create any sequence to MIGRATIONS;  
  
  
 
  
  
grant create any table to MIGRATIONS;  
  
  
 
  
  
grant create any trigger to MIGRATIONS;  
  
  
 
  
  
grant create any view to MIGRATIONS;  
  
  
 
  
  
grant create materialized view to MIGRATIONS with admin option;  
  
  
 
  
  
grant create public synonym to MIGRATIONS with admin option;  
  
  
 
  
  
grant create role to MIGRATIONS;  
  
  
 
  
  
grant create session to MIGRATIONS with admin option;  
  
  
 
  
  
grant create synonym to MIGRATIONS with admin option;  
  
  
 
  
  
grant create tablespace to MIGRATIONS;  
  
  
 
  
  
grant create user to MIGRATIONS;  
  
  
 
  
  
grant create view to MIGRATIONS with admin option;  
  
  
 
  
  
grant drop any role to MIGRATIONS;  
  
  
 
  
  
grant drop any sequence to MIGRATIONS;  
  
  
 
  
  
grant drop any table to MIGRATIONS;  
  
  
 
  
  
grant drop any trigger to MIGRATIONS;  
  
  
 
  
  
grant drop tablespace to MIGRATIONS;  
  
  
 
  
  
grant drop user to MIGRATIONS;  
  
  
 
  
  
grant grant any role to MIGRATIONS;  
  
  
 
  
  
grant insert any table to MIGRATIONS;  
  
  
 
  
  
grant select any table to MIGRATIONS;  
  
  
 
  
  
grant unlimited tablespace to MIGRATIONS with admin option;  
  
  
 
  
  
grant update any table to MIGRATIONS; 
 
 

Click the plus sign in connection again to add a connection using the user you just created.

After the connection, right-click the connection and choose "export data file library"> "link to transplant data file library". The program will create tables and stored procedures required for the transplant data file library under the user, A dialog box is displayed, showing the progress of the Creation.

Source: http://www.cnblogs.com/hiizsk/archive/2011/07/10/2102454.html.