数据帝

#所需的所有包-------------------------------xscreensaver-4.18-5.rhel4.2gnome-libs-1.4.1.2.90-44.1compat-db-4.1.25-9gcc-3.4.3-22.1.EL4gcc-c++-3.4.3-22.1.EL44libstdc++-devel-3.4.3-22.1pdksh-5.

SQL> conn hr/hrConnected.SQL> select * from tab;TNAME TABTYPE CLUSTERID------------------------------ ------- ----------REGIONS TABLECOUNTRIES TABLELOCATIONS

local_listener参数有两种书写格式，提供了不同的功能。监听文件上，1521和1526端口上都有动态监听端口。[oracle@dbsv admin]$ cat listener.ora LISTENER= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=dbsv)(PORT=1521))

当同组的redolog文件，丢失部分成员时，可以使用clear logfile语句进行重建

ocm考试新题中，需要创建keep存储的表，但在该参数是否应该修改上，有一些分歧，有人说asmm会自动给keep分配内存的，该参数就不用设置了。看文档和asktom，也是云山雾罩，说什么的都有，还是来实际的测试吧：SQL> col COMPONENT for a30SQL> select COMPONENT,CURRENT_SIZE/1024/1024||'MB' MB from V_$

datafile block block size :8192Offset0123456789abcdef0001400006A200000A0040010E89430000000502 type

误操作expdp st/st dumpfile=full2013.dmp full=y logfile=full2013.log directory=expdp job_name=my_jobctrl + c 停止发现导出文件依然在增长expdp st/st attach=my_job查看job状态[oracle@test60 expdp]$ expdp st/st

PlatformOracle Database 10g Enterprise Edition Release 10.2.0.2.0Oracle Enterprise Manager 10g Grid Control Release 10.2.0.1.1Operating System:Oracle Enterprise Linux 5 Update 4 (OEL 5 Upd

1.配置/etc/oratab文件文件格式：$ORACLE_SID:$ORACLE_HOME:echo orcl:/u01/oracle:Y >> /etc/oratab2.编写启动脚本vi /etc/init.d/oracleORA_HOME=/u01/oracleORA_OWNER=oracleif [ ! -f $ORA_HOME/bin/dbstart

本来想看下默认表空间的有效范围CREATE bigfile TABLESPACE "USERS" DATAFILE'/u01/oradata/orcl/users.dbf' SIZE 500MAUTOEXTEND ON NEXT 20MLOGGING ONLINE PERMANENT BLOCKSIZE 8192EXTENT MANAGEMENT LOCAL AUTOALL

oracle 10.2.0.1 Linux_x86_64 在dbca建库时，报错ora-27125错误。[root@oel ~]# id oracle uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba) context=root:system_r:unconfined_t:SystemLow-SystemHigh

环境OEL5.9 x86_64oracle10g 10.2.0.1 x86_64把升级包p8202632_10205_Linux-x86-64.zip传入服务器并解压，如下。[root@oel ~]# cd /u01/[root@oel u01]# lltotal 2005592-rw-r--r-- 1 oracle oinstall 801603584 Jun

drop table t1;create table t1 (c1 char(2) primary key, c2 char(1) not null);insert into t1 values ('A ','A'); select t1.c1 from t1 where t1.c1 in (select c2 from t1 union all select '0'||c2 c2 fr