Deployment Table backup considerations

Action Command or Notes Table Name Length in Characters SELECT LENGTH(‘MYNEWTABLE’) “Should be less than 30” FROM DUAL;— Also not table name should only be alpha-numeric and ‘_’— Do not ever put table name in quotes Create a backup table (CTAS) CREATE TABLE <new table_name>asSELECT * FROM <source table_name> ; — Verify row counts matchselect … Continue reading Deployment Table backup considerations