一个库建好后,怎样再重新命名? 谢谢
解决方案 »
- win2008下安装9i的问题
- 急,求助
- ORacle语句性能优化帮助。
- 怎么设置oracle的日期问题,达人解答啊
- 关于机器名和IP变更引发oracledbconsole服务无法启动,很奇怪,如何解决?急!
- Unix下Oracle数据库连接问题,急请高手帮助!!!
- oracle中对树形结构的查询,我想除了得到一列显示起始节点到当前节点的完整路径path外,还要有一列class2,如何实现?
- 关于事务的问题,我都快没耐性了..请大家帮忙,我想把创建表,往表中插入记录,这一系列操作放在一个事务中完成,怎么当事务回滚的时候,这些表
- 请问Oracle里的自动增加字段是哪个?
- oracle
- oracle9i中已经建好的表怎么调出生成此表的sql,有了生成表的sql在哪里执行生成新表
- pl-sql连接本地服务器(Oraclei)
如果是重命名数据库的名字,用nid工具。
RENAME GLOBAL_NAME TO test;
oracle_sid='205'
service_name='205'
dbname='205'
global_dbname='205';new:
oracle_sid='206'
service_name='206'
dbname='206'
global_dbname='206';step:
1.
a. copy e:\zzdb\m205 f:\zzdb\m205;
b. f:\zzdb>rename m205 m206;
c. f:\zzdb\oradata>rename m205 m206;
2.
a. f:\zzdb\pfile\init.ora;
b. instance_name=m205 change to instance_name=m206;
c. change all paramater of init.ora`s path=f:\zzdb....and so on;3. add to oralce listener.ora
(SID_DESC =
(GLOBAL_DBNAME = m206)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = m206)
)
4. go into oracle tnsnames.ora
M205_DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 198.168.1.170)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = m206)
)
)5. create new instancedelete: oradim -delete -sid m206
create: oradim -new -sid m206 -intpwd future -startmode a -pfile f:zzdb\m206\pfile.init.ora 6. create initm206.ora in d:\oracle\ora92\database\
7. intializtion m206a. conn sys/future@m205_db as sysdba
b. shutdown abort
c. startup or startup pfile=d:\oracle\ora92\database\initm206.ora8. change dbnamea. conn sys/future@m205_db as sysdba
b. shutdown normal/immediate
c. host nid targer=sys/future@m205_db dbname=206 setname=yes;
d. shutdown abort;
e. set init.ora`db_name=m206;
f. to step 9
g. restart oracle` listener and db service
h. d:\oracle\ora92\database>del pwdm206.ora
i. host orapwd file=d:\oracle\ora92\database\pwdm206.ora password=future;
j. shutdown abort
k. startup9. change tnsname.ora
m206_DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 198.168.1.170)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = m206)
)
)10. make sure
a. conn sys/future@m206_db as sysdba
b. select dbid,name,log_mode from v$database;
c. select instance_name,host_name,version,status from v$instance;
RENAME FILE '路径+文件名'TO '路径+文件名'
不知道是不是这样子哈.