Create user and assign table space to user--user authorization--Guide library, Oracle build table Space

First of all: I refer to the online use of the SYSDBA mode (normal) landing, the other model can not be built by the user (the individual does not make other modes of table space attempt, such as someone trying to welcome the supplement, grateful)

The table space is equivalent to the container of the table (all operations are applicable to oracle10g):

--Build table space

Create Tablespace SOA--soa is the name of the tablespace

DataFile ' d:\ a.dbf ' size 50m--the storage path of the ' D:\ a.dbf ' tablespace
Autoextend on next 50m maxsize 20480m----autoextend on auto Grow
Extent management Local;

--Create User default assignment SOA table space
Create user Shgbyp identified by "111111"
Default Tablespace SOA;

Log an error

At first I was using the build user statement is the Create users shgbyp identified by 111111 default Tablespace SOA;

The difference is that you don't use double quotes at the password.

reported a oracle10g exclusive error ORA-00988: The password is missing or invalid

It is understood that this error is a 10g error, so 11g users do not have to worry.

--Authorization to the user
Grant CONNECT,RESOURCE,DBA to Shgbyp;

--Import and export
Imp shgbyp/[email protected] file= "E:\20170310.dmp" Full=y ignore=y

--The corresponding delete table space

Drop tablespace SOA including contents and datafiles

--Delete User

Drop User SHGBYP Cascade

Here is the emphasis: delete user Shgbyp, just delete the user under the schema objects, do not delete the table space assigned to the user. Should be for the table space is only for your users, you do not have a user only represents this table space less a user to use!

Create user and assign table space to user--user authorization--Guide library, Oracle build table Space