I forgot to enable Clear temporary objects before a deployment and now there are multiple temporary tables that I want to drop. Suppose, they all start with L1_ so is there any simple query that would allow me to drop them all at once?
Best Answer
G
Gaurav Srivastava
said
over 2 years ago
If this need to be done in one shot, I would suggest using a database management tool which can help selecting multiple tables and drop them at once, for example DBeaver.
Other solutions using XDI are:
- Reverse all these tables and use the tool "AUTOMATION Rdbms Operation" from the Palette.
- Design a process using an SqlOperation action which lists these tables and bind it to another SqlOperation which does the DROP for each table.
Caution: this cannot be cancelled, make sure you select only those temporary tables you want to drop.
1 Comment
G
Gaurav Srivastava
said
over 2 years ago
Answer
If this need to be done in one shot, I would suggest using a database management tool which can help selecting multiple tables and drop them at once, for example DBeaver.
Other solutions using XDI are:
- Reverse all these tables and use the tool "AUTOMATION Rdbms Operation" from the Palette.
- Design a process using an SqlOperation action which lists these tables and bind it to another SqlOperation which does the DROP for each table.
Caution: this cannot be cancelled, make sure you select only those temporary tables you want to drop.
Gaurav Srivastava
I forgot to enable Clear temporary objects before a deployment and now there are multiple temporary tables that I want to drop. Suppose, they all start with L1_ so is there any simple query that would allow me to drop them all at once?
If this need to be done in one shot, I would suggest using a database management tool which can help selecting multiple tables and drop them at once, for example DBeaver.
Other solutions using XDI are:
- Reverse all these tables and use the tool "AUTOMATION Rdbms Operation" from the Palette.
- Design a process using an SqlOperation action which lists these tables and bind it to another SqlOperation which does the DROP for each table.
Caution: this cannot be cancelled, make sure you select only those temporary tables you want to drop.
Gaurav Srivastava
If this need to be done in one shot, I would suggest using a database management tool which can help selecting multiple tables and drop them at once, for example DBeaver.
Other solutions using XDI are:
- Reverse all these tables and use the tool "AUTOMATION Rdbms Operation" from the Palette.
- Design a process using an SqlOperation action which lists these tables and bind it to another SqlOperation which does the DROP for each table.
Caution: this cannot be cancelled, make sure you select only those temporary tables you want to drop.
-
File external resolver with encrypted value
-
Timeout on Mapping/Webservice call
-
UNIQUE TEMP TABLE NAMES
-
Previous step name from a sub-process of execute delivery
-
Freeze Designer and corrupted workspace
-
FileWait/Move/Copy: FileInclude with space
-
Loop excel files
-
Change SVN user in the Designer
-
How to Specify the JVM used by the Designer?
See all 64 topics