Oracle question

[Moose423956]

Supplementary question.

Given that I have gone for the "CREATE TABLE..." option, what code would I need to write to copy them back into the original table from the backup table, after deleting them from the original table?

I'm going to have a go at writing it...please don't laugh if I get it wrong.

INSERT INTO original_table
SELECT * FROM backup_table

Is it that simple?

[lilelvis2000]

It looks okay to me....unless of course there is a sequence counter and you need to preserve the sequence number. In which case you'll need to turn that off.

Otherwise looks good...but I'm not a guru.

[TheFaQQer]

Supplementary question.

Given that I have gone for the "CREATE TABLE..." option, what code would I need to write to copy them back into the original table from the backup table, after deleting them from the original table?

I'm going to have a go at writing it...please don't laugh if I get it wrong.

INSERT INTO original_table
SELECT * FROM backup_table

Is it that simple?

I guess it didn't go well

Yes, that code should do it.

[Moose423956]

I guess it didn't go well

It was a "just in case" question. Just done the delete, and it went okay.

[DBA_bloke]

If no constraints, then, after CTAS:

"DROP TABLE orginal_table PURGE;"
then:
"ALTER TABLE backup_table RENAME TO original_table;"