teradata truncate table

Standby Library Open Flashback database#关闭备库的同步SQL> alter database recover managed standby database cancel;Database altered.SQL> select flashback_on from v$database;FLASHBACK_ON------------------NOSQL> alter database flashback on;Database altered.SQL> select flashback_on from v$database;FLASHBACK_ON------------------YESSQL> alter database recover managed standby database using current logfile disconnect;Database altered.View sync status, archive for real-time application of Master Library#主库上执行S

How to recover the Delete/update data Operation Steps 1 db connected to the deleted database Open Log Explorer Select "File"-> "Attach log File"-> Select server and login mode-> "Connect"-> Select "Database"-> "Attach" 2 View Log In the dialog box on the left action item, select the Browse item-> "View Log"-> to see the current log record. 3 Recovery dataRight-click a log record, select "Undo Transation"-> "Choose Save file name and path"-> then open the file to Query Analyzer to performT-SQL co

Tags: perform trunc row store cut replace exec cal BSP ACLI. Create a stored procedure under INS user Second, Mobapp user empowerment: Execute the permissions of the stored procedure Third, the Odso_insert user executes the stored procedure, can truncate the table View Odso_insert user-owned permissions I. Create a stored procedure under INS user 1 2 3 4 5 6 7 createorreplace procedure

Get ready:To say that truncate table is going to have to talk about the delete all two of them can be used to delete data rows from the table! On the face of it, delete deleted slowly, TRUNCATE TABLEFaster,Delete:It is an honest line of deleted data, write logs, and the data it deletes can be recovered through the log.