What to do after the Oracle database is created

Log in to the database with Conn/as sysdba.

First: Create a new user

Create User  by test02 (test01 for user name, test02 for user password)

Second: Give basic permissions to database operations

Grant  to test01;

Three: Create a table space

Create the appropriate tablespace according to the appropriate requirements.

CREATE tablespace edutables datafile   ' D:\app\Administrator\oradata\test\EDUTABLES01. DBF' size 32000M on  NEXT 500M MAXSIZE UNLIMITED;

In more detail, I usually use the above.

CREATE tablespace edutables datafile  ' F:\app\Administrator\oradata\test\EDUTABLES01. DBF'  SIZE 4596M autoextend on NEXT 500M MAXSIZE unlimitedloggingonlineextent MANAGEMENT LOCAL Autoa Llocateblocksize 8KSEGMENT SPACE MANAGEMENT autoflashback on;

Four: Create a table space, is the time to guide the database, the full database backup export, and then use a batch file, execute.

Import and export can find this blog: http://www.cnblogs.com/newlooker/p/3564939.html

At this point, data recovery is complete

Another problem is to import the database full backup, sequence the value of the problem is smaller than some of the data table ID, is not sequence will not be imported together?