1.Oracle的备份
备份:exp user/password full=y file=filename.dmp;
恢复:imp user/password full=y file=filename.dmp。
恢复:imp user/password full=y file=filename.dmp。
2.oracle改用户
conn /as sysdba;
alter user system identified by manager;
alter user system identified by manager;
3.SQL里修改列的默认值
sp_help 'T_Data_bbs_ylds..bbstitle'
ALTER TABLE ADDRESSBOOK_TABLE
drop constraint x
ALTER TABLE ADDRESSBOOK_TABLE
ADD CONSTRAINT x DEFAULT ('liyan') FOR NAME
drop constraint x
ALTER TABLE ADDRESSBOOK_TABLE
ADD CONSTRAINT x DEFAULT ('liyan') FOR NAME