User has altered a table and changed tablespace name then expected to see export/import on script but it was not there.
Â
Table was empty
Toad generated script issues a DROP as one of the first things it does, then that signals that the TABLE has no rows. You can do a "SELECT COUNT(*) FROM tablename" to verify no rows in the table. If Toad detects there is data, then it may generate an IMPORT/EXPORT or define a new TABLE first and then populate it with an INSERT FROM (SELECT *) from the old table. This behavior is selected using: Options/Database/DB2/Advanced Admin/Preserve Data Method.
Â
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center