Teradata Database Message 3553 - 3553 - Analytics Database - Teradata Vantage

Message

The user cannot RENAME to a new database.

Explanation

The target table name in a RENAME statement is in a different database than the source table name.

Generated By

OPT modules.

For Whom

End User.

Notes

None

Remedy

Use a CREATE TABLE statement followed by an INSERT statement with a query specification to move the table to a new database.