xuguiyi100的专栏

<br />-- Create the user <br />create user user<br />  identified by "123456"<br />  default tablespace USERS<br />  temporary tablespace TEMP<br />  profile DEFAULT<br />  password expire;<br />-- Grant/Revoke role privileges <br />grant connect to user;<

1.创建表空间和用户echo "登录SQL*PLUS" 表空间用户.sql 后面跟四个参数,依次为:表空间名,数据文件路径,新建用户名,密码sqlplus "system/manager@ORCL as sysdba" @表空间用户.sql ts_name D:ORCL/oradata/ts_name.DAT user passpause2.授权GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,    DROP ANY VIEW,EXP_FUL

SYBASE、ORACLE函数对比 Sysdate        Oracle取系统时间用“select sysdate from dual”查询语句。        Sybase取系统时间用“select getdate()”查询语句。 Decode        Oracle的“select decode(IPAddressB,null,' ',IPAddressB) from re

--1：创建临时表空间 create temporary tablespace spa_authsys_temp   tempfile 'F:\soft64\ora11g\oradata\orcl\my\authsys_temp.dbf'  size 50m   autoextend on   next 50m maxsize 1024m   extent management loc