在Python for Oracle中批量创建表，失败时进行回滚

import cx_Oracle

# 连接到Oracle数据库
connection = cx_Oracle.connect("username", "password", "host:port/service_name")

# 创建游标
cursor = connection.cursor()

# 开始事务
connection.begin()

try:
    # 批量创建表
    cursor.execute("CREATE TABLE table1 (id NUMBER, name VARCHAR2(50))")
    cursor.execute("CREATE TABLE table2 (id NUMBER, address VARCHAR2(100))")
    cursor.execute("CREATE TABLE table3 (id NUMBER, email VARCHAR2(100))")

    # 提交事务
    connection.commit()
    print("表创建成功！")
except cx_Oracle.DatabaseError as e:
    # 发生异常时回滚事务
    connection.rollback()
    print("表创建失败，回滚事务！")
    print("错误信息：", e)
finally:
    # 关闭游标和连接
    cursor.close()
    connection.close()