Oracle uses commands to import DMP files

To import to a specific table space, you need to create a new tablespace, and if not, use the one you already have, just follow the steps below

Enter IMP username/password in the DOS window @ip address: Port number/DB instance file= ' path of the DMP file to be imported ' full = y (may be required)

Here are the steps to create a tablespace and a user:

1. user   
2. build: create user  User name  identified by  "password";   
3. Authorization: grant create  session to  user name;   
4. < span class= "keyword" >grant create table  to   user name;   
5. grant create tablespace  to   user name;  

1. Create a tablespace (typically a table space with n stored data and an index space):
2. Create tablespace table space name
3. DataFile ' Path (to build the path first) \***.dbf ' size *m
4. Tempfile ' path \***.dbf ' size *m
5. Autoextend on -automatic growth
6. --There are some commands to define the size, see the need
7. Default Storage (
8. Initial 100K,
9. Next 100k,
10. );

1. Example: creating a table space
2. Create tablespace aside
3. DataFile ' F:\app\Aside\oradata\orcl\Aside.dbf '
4. Size 100M
5. Autoextend on next 5M maxsize 3000M;
6. Delete Table space
7. Drop tablespace aside including contents and datafiles

1. User Rights
2. To grant a user permission to use the tablespace:
3. Alter user username quota Unlimited on table space;
4. or alter user username quota *m on table space;

Oracle uses commands to import DMP files