Before creating a user name, you need to log on to the database as a user Administrator 1, to create a table space before creating a user:
The format is: Format: Create tablespace table name datafile ' data file name ' size table space;
For example:
sql> Create tablespace mytable datafile ' d:\myoracle\mytables1.dbf ' size 1024M segment space management auto;
If the table space is insufficient to import data, you can modify the table space as follows:
Sql>alter database datafile ' d:\myoracle\mytables1.dbf ' autoextend on;
Delete namespaces
Sql>drop tablespace tablespace including CONTENTS and datafiles CASCADE;
2. Create User
The format is: Format: Create user username identified by password default Tablespace table space table;
Such as:
Sql> create user Itms identified by 123456 default Tablespace mytable;
The default table space ' default Tablespace ' uses the tablespace created above.
Then authorize to the newly created user:
Sql> Grant Connect,resource to Itms; – Represents the granting of Connect,resource permissions to ITMS users
Sql> Grant DBA to Itms; – Indicates the success of granting DBA authority to the ITMS user. 3, Import table DMP file
Exit login, enter in cmd:
Imp ITMS/123456@ORCL file=e:\mrs_2015.dmp full=y
Note: Do not ignore full=y, and do not separate input, there will be error prompts.