惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

H
Help Net Security
博客园 - Franky
GbyAI
GbyAI
Threat Intelligence Blog | Flashpoint
Threat Intelligence Blog | Flashpoint
爱范儿
爱范儿
IT之家
IT之家
酷 壳 – CoolShell
酷 壳 – CoolShell
aimingoo的专栏
aimingoo的专栏
博客园_首页
MongoDB | Blog
MongoDB | Blog
CTFtime.org: upcoming CTF events
CTFtime.org: upcoming CTF events
Recent Announcements
Recent Announcements
Scott Helme
Scott Helme
有赞技术团队
有赞技术团队
M
MIT News - Artificial intelligence
C
CERT Recently Published Vulnerability Notes
K
KPMG report finds enterprise disconnect between AI and its ROI | CIO
Jina AI
Jina AI
F
Fortinet All Blogs
N
Netflix TechBlog - Medium
L
LangChain Blog
L
LINUX DO - 最新话题
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
cs.AI updates on arXiv.org
cs.AI updates on arXiv.org
H
Hacker News: Front Page
MyScale Blog
MyScale Blog
P
Palo Alto Networks Blog
G
Google Developers Blog
Google DeepMind News
Google DeepMind News
AI
AI
T
Troy Hunt's Blog
Microsoft Azure Blog
Microsoft Azure Blog
阮一峰的网络日志
阮一峰的网络日志
cs.CL updates on arXiv.org
cs.CL updates on arXiv.org
Vercel News
Vercel News
Microsoft Security Blog
Microsoft Security Blog
罗磊的独立博客
S
Secure Thoughts
大猫的无限游戏
大猫的无限游戏
博客园 - 叶小钗
人人都是产品经理
人人都是产品经理
Blog — PlanetScale
Blog — PlanetScale
博客园 - 司徒正美
Apple Machine Learning Research
Apple Machine Learning Research
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
博客园 - 三生石上(FineUI控件)
S
Security @ Cisco Blogs
Cloudbric
Cloudbric
E
Exploit-DB.com RSS Feed
Attack and Defense Labs
Attack and Defense Labs

博客园 - Day Day Up

Weekday 回来太多事需要处理 He Fei ,First ,Good Luck develop business how to control project one colleague is ill For ITS ASP Project,some ideas 世上最强的中国式英语 Top 100 good english words Useful Engish Welcome 常见测试术语 组件测试-多个单元和数据对象间的互操作性,被调用的Subroutines,Data,etc Daily Building specification 每日构造与冒烟测试 Think it over before you just! 改变人一生的5句话 软件开发组的-- 团队精神 <<情竹>>的清爽笛声
sql server 怎么样实现远程备份,用程序的方法
Day Day Up · 2005-03-01 · via 博客园 - Day Day Up

第一步:确认你要备份的机上的帐户和密码跟你登录的一样或备份机的GUEST帐户打开并有访问共享文件夹的权限
要是域用户就填域名\用户名
工作组就填计算机名\用户名
第二步:企业管理器的SQL属性里的安全性选项选本帐号

backup database 数据库名 to disk='UNC名'
///////////////////////////////////////////////////////////////
软件环境:
1、Windows NT4.0+ORACLE 8.0.4
2、ORACLE安装路径为:C:\ORANT

实现方法:
SQL> conn sys/change_on_install
SQL> desc props$
SQL> set arraysize 1
SQL> col value$ format a40--格式化value$的输出为40个字符宽
SQL> select name,value$ from props$ where name='NLS_CHARACTERSET';

SQL> conn system/manager
SQL> select * from nls_database_parameters;
SQL> select * from V$NLS_PARAMETERS;

SQL> select * from nls_database_parameters;

PARAMETER                                value
---------------------------------------- -------------------
NLS_LANGUAGE                             AMERICAN
NLS_TERRITORY                            AMERICA
NLS_CURRENCY                             $
NLS_ISO_CURRENCY                         AMERICA
NLS_NUMERIC_CHARACTERS                   .,
NLS_CALENDAR                             GREGORIAN
NLS_DATE_formAT                          DD-MON-YY
NLS_DATE_LANGUAGE                        AMERICAN
NLS_CHARACTERSET                         ZHS16GBK
NLS_SORT                                 BINARY
NLS_NCHAR_CHARACTERSET                   ZHS16GBK
NLS_RDBMS_VERSION                        8.0.4.0.0

查询到12记录.

SQL> select * from V$NLS_PARAMETERS;

PARAMETER                                value
---------------------------------------- -------------------
NLS_LANGUAGE                             SIMPLIFIED CHINESE
NLS_TERRITORY                            CHINA
NLS_CURRENCY                             RMB
NLS_ISO_CURRENCY                         CHINA
NLS_NUMERIC_CHARACTERS                   .,
NLS_CALENDAR                             GREGORIAN
NLS_DATE_formAT                          DD-MON-YY
NLS_DATE_LANGUAGE                        SIMPLIFIED CHINESE
NLS_CHARACTERSET                         ZHS16GBK
NLS_SORT                                 BINARY
NLS_NCHAR_CHARACTERSET                   ZHS16GBK

查询到11记录.