> 
> **Possible Duplicate:**  
> 
> [Moving Data from SQL Server to Oracle Repeatedly](https://stackoverflow.com/questions/571051/moving-data-from-sql-server-to-oracle-repeatedly) 
> 
> 
> 

Is it possible to copy a table from SQL Server to a new table in Oracle?

I am pretty sure that it is not possible, but I would like an expert confirmation and how if it exists.

```
CREATE TABLE `backup_db.backup_table` 
  SELECT * FROM `live_db.live_table`;

```

**EDIT**

To be more clear, I need to copy this table every day from SQL Server to Oracle.

I know that it is not elegant, but I have no other choice.