Oracle creates a new user and imports a datasheet dmp file ____oracle

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.