From c70d7226ee1ced742b0ef4536e2c33aa480a437f Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Thu, 4 Feb 2016 13:59:32 -0500 Subject: [PATCH] - add a session killer for oracle provisioning --- lib/sqlalchemy/testing/provision.py | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/lib/sqlalchemy/testing/provision.py b/lib/sqlalchemy/testing/provision.py index 0feb419873..588a5e1129 100644 --- a/lib/sqlalchemy/testing/provision.py +++ b/lib/sqlalchemy/testing/provision.py @@ -258,6 +258,11 @@ def _oracle_configure_follower(config, ident): @_drop_db.for_db("oracle") def _oracle_drop_db(cfg, eng, ident): with eng.connect() as conn: + for row in conn.execute( + "select sid, serial# from v$session " + "where username='%s'" % ident.upper()): + sid, serial = row + conn.execute("alter system kill session '%s, %s'" % (sid, serial)) conn.execute("drop user %s cascade" % ident) conn.execute("drop user %s_ts1 cascade" % ident) conn.execute("drop user %s_ts2 cascade" % ident) -- 2.47.2