How do we create temporary tables/session tables? We are planning to migrate from Oracle to CockroachDB. Please let us know the possibility or the alternatives. Thank you.
It’s on the roadmap: https://github.com/cockroachdb/cockroach/issues/13517
Alternative is to create/delete regular tables…
FYI: we recently moved our roadmap to our Github wiki. This is the version we’ll maintain going forward.
Temporary tables are indeed on our backlog, though the exact timing is still TBD.