Oracle11G数据库的导入导出记录
su - roacle sqlplus /nolog conn /as sysdba show parameter dump_dir expdp system/password directory=dump_dir dumpfile=file.dump logfile=file.log schemas=user1,user2,user3 c:\users\Administrator>sqlplus /nolog
网事随记
su - roacle sqlplus /nolog conn /as sysdba show parameter dump_dir expdp system/password directory=dump_dir dumpfile=file.dump logfile=file.log schemas=user1,user2,user3 c:\users\Administrator>sqlplus /nolog
删除作业 use [msdb] declare @job_name varchar(100) set @job_name = N'正式库每天凌晨3:00第二次完整备份.Subplan_1' --注:job_name为维护计划对应的job name --删除在计划里面的日志 delete sysmaintplan_log from sysmaintplan_subplans as subplans inner join sysjobs_view as syjobs on subplans.job_id = syjobs.job_id
主库创建用户,获取用户sid select sid from sys.sql_logins where name = 'NAME' 在辅助副本上 create login NAME with password='PASSWOED', sid=SID ------------------------------------------------------ 原库执行,获取sid select [name], sid from syslogins where [name] = 'user'
Windows登陆后只有命令行窗口,没有图形界面,explorer.exe不能启动,并且explorer.exe 文件不存在 命令行执行: Dism /online /enable-feature /all /featurename:Server-Gui-Mgmt /featurename:Server-Gui-Shell /featurename:ServerCore-FullServer
C:\program files\update services\tools
wsusutil.exe movecontent
V