如何将AWS Aurora postgresql中的数据作为python数据帧读取并将其写入Oracle表？

Question

我需要从AWS-Aurora表中读取内容并将其写入Oracle表。 我的密码是-

import pandas as pd
import psycopg2
from sqlalchemy import types, create_engine
import cx_Oracle
import sys

**# Connect to Aurora**
host = sys.argv[1]
username = sys.argv[2]
password = sys.argv[3]
database = sys.argv[4]

db_conn = psycopg2.connect(host=host, database=database, user=username, password=password)
sql = "SELECT * FROM Table_Name;"
data_df = pd.io.sql.read_sql(sql, db_conn)
print(data_df.head(2))
db_conn.close()

# Connect to Oracle and write data_df  dataframe
dsn = cx_Oracle.makedsn('10.z.y.xx', '1521', service_name='abcd')
u_name = sys.argv[5]
pwd = sys.argv[6]

conn = cx_Oracle.connect(user=u_name, password=pwd, dsn=dsn)
ora_engine = create_engine(f'oracle+cx_oracle://{u_name}:{pwd}@{dsn}', echo=True)
ora_engine.connect()
data_df.to_sql(name='oracle_table_name', con=conn)
conn.close()

连接到Aurora正在工作，但我无法在Oracle中创建引擎并编写数据帧

Answer 1

代码是正确的，由于配置了大量数据和较低的RAM，因此出现了故障

谢谢