David E. Wheeler

It sounds like for some reason Snowflake is not letting the user create the table. That query failing is expected; Sqitch catches that error and then knows to try to...

See if you can create a schema and a table with that user via SnowSQL. Copy the command line arguments from [this example](#issuecomment-882588288). If it fails, you'll need to figure...

Yep: https://github.com/sqitchers/sqitch/blob/ef7767d83d396e98c7a57222f1765bcda6189809/lib/App/Sqitch/Engine/oracle.pm#L112-L118 It gets created here: https://github.com/sqitchers/sqitch/blob/ef7767d83d396e98c7a57222f1765bcda6189809/lib/App/Sqitch/Engine/oracle.pm#L461-L464 But the [Oracle registry script](/sqitchers/sqitch/blob/develop/lib/App/Sqitch/Engine/oracle.sql) doesn't create the schema (user). Instead, according to the [tutorial](/sqitchers/sqitch/blob/develop/lib/sqitchtutorial-oracle.pod#our-first-change), it just uses the current schema. From the...

I just worked through it all again, committing 8be3608c to improve the consistency of handling the registry username. But I still can't work out how this is happening, unless it's...

No output at all? Weird. What happens if you try to print the schema name in `initialized()`?

IIRC, it currently defaults to the current database if the `sqitch` registry doesn't exist, but it shouldn't fall back if the registry schema name is explicitly named, as in your...

#762 should fix the issue. It detects when the registry schema does not exist at connection time, and doesn't bother to call `_select_state()` if it doesn't exist.

Ugh, yeah, that's quite the edge case, but a very real possibility. The only solution I can think of offhand is to schema-qualify the `changes` table in that query —...

Him, [the docs](https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/ALTER-SESSION.html#GUID-8DBA8659-413E-49B4-98D3-D9608C9C8026) suggest that `ALTER SESSION SET CURRENT_SCHEMA` changes the default schema. I don't see anything about it falling back on the previous default schema, or a schema path....

Tried it out, works great, thanks!