Linux下安装Oracle 11g
传送门:
http://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/229016_zhs.htm
登陆oracle
>su - oracle
>sqlplus /nolog
管理员登陆
>conn /as sysdba
用户登陆
>conn username/password
远程用户登陆
>conn username/password@ip:1521/ORCL
当前登陆用户
>show user;
执行SQL文件(适合大文件)
>conn user/pwd
>@/路径/sql.sql;
存储查询结果
>spool d:\1.txt
>select * from emp;
>spool off