oracle 默认表空间 10g,ORACLE 10G创建表空间和创建用户

ORACLE 10G创建表空间和创建用户

1、创建表空间

CREATE TABLESPACE mytablespace DATAFILE

'F:\oracle\product\10.2.0\oradata\myoracle\MYTABLESPACE01.DBF' SIZE 500M AUTOEXTEND ON NEXT

100M MAXSIZE UNLIMITED

LOGGING

PERMANENT

EXTENT MANAGEMENT LOCAL AUTOALLOCATE

BLOCKSIZE 8K

SEGMENT SPACE MANAGEMENT MANUAL

FLASHBACK ON;

2、创建用户

CREATE USER ECC_NOTE IDENTIFIED BY sys

PROFILE DEFAULT

DEFAULT TABLESPACE mytablespace

TEMPORARY TABLESPACE temp

ACCOUNT UNLOCK;

GRANT UNDER ANY TABLE TO ECC_NOTE WITH ADMIN OPTION;

GRANT UNDER ANY TYPE TO ECC_NOTE WITH ADMIN OPTION;

GRANT UNDER ANY VIEW TO ECC_NOTE WITH ADMIN OPTION;

GRANT "DBA" TO ECC_NOTE WITH ADMIN OPTION;

GRANT "OLAP_DBA" TO ECC_NOTE WITH ADMIN OPTION;

GRANT "OLAP_USER" TO ECC_NOTE WITH ADMIN OPTION;

GRANT "SELECT_CATALOG_ROLE" TO ECC_NOTE WITH ADMIN OPTION;

ALTER USER ECC_NOTE DEFAULT ROLE "DBA", "OLAP_DBA", "OLAP_USER", "SELECT_CATALOG_ROLE";

ALTER USER test QUOTA UNLIMITED ON ECC_NOTE;

相关文档：

单表数据迁移：支持clob,blob

exp estarcom/estarcom@ORACLE  tables=AA direct=y file=C:/AAA1.dmp

imp estarcom/estarcom@ORACLE  tables=AA  file=C:/AAA1.dmp fromuser=estarcom touser=estarcom

全库数据迁移

exp userid=zhongxin/zhongxin@ORACLE own ......

Q1.怎样创建表？

Q2.怎样删除表？

Q3.怎样创建视图？

Q4.怎样删除视图？

Q5.怎样给表添加字段？

Q6.怎样删除表中某个字段？

Q7.怎样给某个字段添加约束？

Q8.怎样去除某个字段上的约束？

Q9.怎样给表加上主键？

Q10.怎样删除表的主键？

Q11.怎样给表添加一个外键？

......

源贴地址:http://topic.csdn.net/u/20090520/15/08a03d2e-a537-4c06-b79a-7e2f7ed5f898.html

1,

ASCII

返回与指定的字符对应的十进制数;

SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;

A A ZERO SPACE

--------- --------- --------- ---------

65 97 48 32

2. CHR ......

//向数据库中写入

private void button1_Click(object sender, EventArgs e)

{

oracleConnection1.Open();

& ......