drop table t purge is not the same as truncate.
the purge just allows for the space to be immediately reused, it is not in the recycle bin
truncate changes the tables data object id, points it to new space, changes the TABLE entirely.
they are different commands.
the purge just allows for the space to be immediately reused, it is not in the recycle bin
truncate changes the tables data object id, points it to new space, changes the TABLE entirely.
they are different commands.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29646619/viewspace-1165609/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
