Hi,
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
Thanks.