常用oracle sql语句

 

创建表空间

ALTER TABLESPACE NM OFFLINE;

DROP tablespace NM INCLUDING CONTENTS AND DATAFILES;

DROP USER NM CASCADE;

CREATE TABLESPACE NM

    DATAFILE 'xxx1' SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M,

    'xxx2' SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED

    LOGGING ONLINE PERMANENT

    EXTENT MANAGEMENT LOCAL

    SEGMENT SPACE MANAGEMENT AUTO ;

CREATE USER "NM" IDENTIFIED BY "mima" DEFAULT TABLESPACE "NM" TEMPORARY TABLESPACE "TEMP" PROFILE DEFAULT ACCOUNT UNLOCK;

GRANT "CONNECT" TO "NM";

GRANT "RESOURCE" TO "NM";

GRANT UNLIMITED TABLESPACE TO "NM";

ALTER USER "NM" DEFAULT ROLE ALL;

commit;

exp schema/mima@cq_10.40.24.3 file="dddd" log=n owner=(schema)

imp system/mima@10.40.24.3 file=xxx TABLESPACES=TEST1 fromuser=TEST1   touser=TEST1

参考 http://www.knowsky.com/344815.html

 

虚拟光驱: mount -o loop *.iso /mnt/cdrom
creat iso:dd if=/dev/cdrom of=*.iso

http://127.0.0.1:9080/WSsamples
http://127.0.0.1:9090/admin
startServer server1
./apachectl start

解压：
tar zxvf x*.tar.gz

打包：  tar -cf *.tar *.*
增加文件：  tar  -rf *.tar  *.*
解包：   tar -xf *.tar
打压缩包：tar -czf *.tar.gz  *.*
解 *.gz : gunzip  *.gz

查看语言包   /etc/sysconfig/i18n
运行 system-config-language

rpm -ivh ttfonts_ZH_CN

自启动： /etc/rc.d/rc.local
查看目录大小:  du -sh  diname
硬盘大小： df -h  
    df-k

永久修改ip
ifconfig  eth0 ip
/etc/sysconfig/network-scripts/ifcfg-eth0
重新启动网络： /etc/init.d/network restart
查看22端口运行的程序：  lsof -i :22

dns:  /etc/reslov.conf
查看端口情况： netstat -rn
停止防火墙： /sbin/service iptables stop
确系统启动时运行 /sbin/chkconfig --level 345 iptables on

host文件位置  /etc/host.conf

jdbc url:  jdbc:oracle:thin:@ip:port:sid

jndi 是什么？
数据库用户名密码是什么？