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

推荐订阅源

D
Docker
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
Last Week in AI
Last Week in AI
博客园_首页
Microsoft Security Blog
Microsoft Security Blog
Blog — PlanetScale
Blog — PlanetScale
M
MIT News - Artificial intelligence
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
A
About on SuperTechFans
aimingoo的专栏
aimingoo的专栏
V
Visual Studio Blog
Jina AI
Jina AI
N
Netflix TechBlog - Medium
量子位
博客园 - 三生石上(FineUI控件)
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
I
InfoQ
J
Java Code Geeks
T
Tailwind CSS Blog
博客园 - 司徒正美
Stack Overflow Blog
Stack Overflow Blog
阮一峰的网络日志
阮一峰的网络日志
Engineering at Meta
Engineering at Meta
腾讯CDC

博客园 - 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记录.