Oracle creates table space Import database

1 first need to enter Oracle with system users

2 then create a table space

Creating a tablespace requires creating two temporary table spaces a table space

-- CREATE TABLE space

Create tablespace ABC datafile ' D:\TABLESPCE\LANDHIGH_SFTMS.DBF ' size 500m;

--Create a user and specify a tablespace

Create user admin identified by admin default tablespace ABC quota 500m on users;

-This is where the database is stored

Create directory Dump_dir as ' D:\tables ';

-- granting permissions to users

Grant read, write on directory dump_dir to admin;

Grant CONNECT,RESOURCE,DBA to admin;

--The import command is in the C-Disk command window

IMPDP Admin/[email protected] directory=dump_dir Dumpfile=sfzs. DMP

Sfzs. DMP is the name of the database

Of course, the above commands can also be executed in the Plsql SQL command

Oracle creates table space Import database