删除数据库中的某个表的数据吗?
备份使用exp命令
删除使用delete 语句
----------------
in your bat file:#backup database
exp .....#delete record from record;
sqlplus @delete.sql;
--------------------
in delete.sql:
delete from ....
备份使用exp命令
删除使用delete 语句
----------------
in your bat file:#backup database
exp .....#delete record from record;
sqlplus @delete.sql;
--------------------
in delete.sql:
delete from ....
rem ____________________
exp system/manager full=y owner=somebody file=c:\backup\backup.dmp log=c:\log\backup.log rows=n
rem 如果有n个用户,则需写n行如上的语句。
rem 下面是删除数据。
sqlplus system/manager @c:\delete.sql
rem delete.sql 文件需要另外写。
exp-00056: 遇到oracle错误2248
ora-02248:无效的alter session 选项
exp-00000:导出终止失败