Forum Stats

  • 3,874,172 Users
  • 2,266,676 Discussions


lb data command leaves spawned sqlcl session connected

user10310346 Member Posts: 3 Green Ribbon


When using sqlcl 22.3.1 lb data command spawns an sqlcl session which remains after command completes. This makes it impossible to drop the test schema being used from the current session as the spawned session is still connected. Once the current session is exited, the spawned session is released.

Note that lb generate-schema also spawns a session but releases it once the command completes.

Session has same osuser and username of session that launches the lb command.

command used was:

lb data -output-file t1_data.xml -include-objects T1

Wondering if anyone else has come across this

I am running sqlcl on Windows