weejar zhang

oracle ACE, A DBA, blogger.

oracle impdp network从备份库导入测试库

by

以前写过一篇oracle 用imp/exp做的数据迁移方法，平时最头痛的就是让从生产库或备份库copy一份最新的数据库到开发的测试库，今天如果在测试库的同一网段有备份库，..

8, impdp system/oracle directory=impdp_dir network_link=tar31 schemas=icme remap_schema=icme:icme2;

关于dict与v$fixed_table

by

dict 里的条数与fixed_table不一样,网上也有说明，在这总结一下

DICT is a synonym for DICTIONARY
DICTIONARY contains descriptions of data dictionary tables and views.

V$FIXED_TABLE This view displays all dynamic performance tables, views, and derived tables in the database. Some V$ tables (for example, V$ROLLNAME) refer to real tables and are therefore not listed.
.

OS Authentication,ORACLE系统认证

by

[zhang@orazhang ~]$ sqlplus /

SQL*Plus: Release 10.2.0.1.0 – Production on Fri Apr 1 12:03:22 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options

SQL> show user
USER is “OPS$ZHANG”

mysql 无法退出sql命令行编辑

by

mysql> insert into core_user(login_name,real_name,password,email,create_time,is_disab…..
‘> quit
‘> exit
‘> bye
‘> ;
‘> \
‘> \c
‘> /c
终止批处理操作吗(Y/N)? y

遇到上面的情况无法终于sql编辑，最后没办法ctrl+c，强退了mysql ,后来找了一下官方文档

oracle随linux OS自动启动与关闭

by

在linux 上装的oracle ，每次开机都要手动启动oracle服务，想做到自动，改了好些天，可能是做的虚拟ASM原因一直服务启动出错，先不说ASM，let oracle instance automatic startup and close

环境：rhel 5 linux +oracle 10g

freewebhostingarea limited country!

by

从前天开始本站在国内大陆 再次不能正常访问，主页跳转去了freewebhostingarea的警告页面（下图）。意思大概就是“所在国家的免费流量被限制了！因为我所在的国家不是 freewebhostingarea面向的主要客户..

MYSQL ERROR 1093 (HY000): You can’t specify target table ‘core_member’ for update in FROM clause

by

今天删除mysql库中几条重复2次的记录，有个序列号member_id，取一个人最大用户名删除,没想到mysql语法还不一样

mysql> delete from core_member where member_id in(select max(member_id) from core_member where user_id in(select user_id from core_user where email=’xiangtan@xiangtan.com’) group by user_id);

ERROR 1093 (HY000):…

oracle create read only view创建只读视图

by

建立只读简单视图 SQL> create table test(id int,name varchar(20)); Table created. SQL> insert into test(1,’anbob.com’); insert into test(1,’anbob.com’) * ERROR at line 1: ORA-00928: missing SELECT keyword SQL> insert into test values(1,’anbob.com’); 1 row created. SQL> insert into test values(2,’weejar.com’); 1 row created. SQL> commit; Commit complete. SQL> select * from test; ID NAME ———- —————————————- 1 … Read more