SQL Server imports data to Oracle

Create a user in Oracle under Windows

Create a user under Oracle to give permission to start SQL Plus in the terminal.
Create user + password (User: sa password: Lenovo)

sql> create user sa identified by Lenovo;

Assign user permissions individually

Sql> Grant create session to SA;
Sql> Grant CREATE table to SA;
Sql> Grant create sequence to SA;
Sql> Grant CREATE view to SA;

Of course, you can also give DBA authority to users

Sql> Grant SYSDBA to SA;

To create an ODBC data source under Windows

Control Panel--Administrative Tools-Data source (ODBC), "System DSN" tab, click the Add button, select the relevant Oracle driver

Configure the data source information as follows

Click on "Test Connection" for testing to see if the Solaris Unicom

SQL Server imports data to Oracle

Start SQL Server Enterprise Manager, and in the database--dbserver "All Tasks", export the data.

According to the prompt, next, in this main configuration "Select the data Source", "Select the purpose", "Select source table and view" and so on, you can see a description

Here in the "Select Source table and view" when the main purpose of the database is to change the name of the table or view name to uppercase and remove the previous user name, you can refer to fill in. To do the next step, in the end, I met a small problem, when importing and exporting Oracle cannot create a table or view, you can see the corresponding prompt "ORA-01950: No permissions to Tablespace ' USERS '."

"ORA-01950: No Permissions for tablespace ' USERS ' Workaround:

When you create a new user, you specify default tablespace, otherwise it treats the system table space as its default tablespace. This is not to be advocated. It is estimated that the default tablespace was not specified when a user was created, and now its permissions to use the system tablespace are retracted by the DBA.

Use the system login in Oracle to execute the following statement

Sql> Connect System/lenovo
sql> ALTER user SA quota unlimited on users;

Try it this time, totally ok!.

Hehe, after the completion of the SQL Server data has been imported into Oracle, and quickly to inquire about it!

SQL Server import data to Oracle