Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to create instances, build libraries, build tables and expand tablespaces in oracle. It is very detailed and has certain reference value. Friends who are interested must finish reading it.

Version: oracle 11g

1. Create an instance (for more information: http://jingyan.baidu.com/article/20095761798412cb0721b4ff.html)

There are two ways to open dbca (db configuration assistance):

. / $ORACLE_HOME/bin/dbca

Directly tap dbca (normal installation + equipped with environment variables) ╮ (╯▽╰) ╭

Second, check the monitoring status

Lsnrctl status

If you have orcllearn, the instance is listening normally, so you can take the next step.

3. Switch the instance name to orcllearn

Echo $ORACLE_SID export ORACLE_SID=orcllearn

Create / delete / expand tablespaces

# create a tablespace create tablespace DEMOSPACE datafile 'E:/oracle_tablespaces/DEMOSPACE_TBSPACE.dbf'size 1500m autoextend on next 5Mmaxsize 3000M maxsize # Delete a tablespace drop tablespace DEMOSPACE including contents and datafiles# extended tablespace alter tablespace sales add datafile' E:/oracle_tablespaces/DEMOSPACE_TBSPACE.dbf'size 800m autoextend on next 50m maxsize 1000m

For reference (including multiple ways to create tablespaces): http://database.51cto.com/art/200910/158936.htm

Fifth, create users

Create user li identified by li;grant create table to li;grant create tablespace to li;grant create view to li;grant create session to li

VI. Create tables

Create table hehe (id number (8) not null, name varchar (20) not null, primary key (id)) are all the contents of the article "how to create instances, build databases, build tables, and expand tablespaces in oracle". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.