Assuming Oracle has an entirely new database ORCL, now it's time to import the database file (. dmp) into this new database ORCL. The detailed steps are as follows: 1. Create a table spaceFor example:Create tablespace Test (tablespace name) datafile ' F:\oracle\oradata\orcl\test.dmp ' (table Space storage location)size 50M (table space size, unit trillion)autoextend on next 50MMaxSize UnlimitedExtent management Local Autoallocatesegment Space management auto; 2. Create a user and assign a tablespace to a userCreate user test (username)identified by test (password)default tablespace Test (table space name); 3. Granting permissions to usersGrant Dba,connect,resource,Aq_administrator_role,aq_user_role,authenticateduser to test (user name); 4. Import data (at the Command Prompt window)imp test/[email protected]buffer=64000File=d:\test.dmp (where the DMP file is located)full=y (full and TABLES are two import modes, TABLES can import only some of the tables, tables= (TAB1,TAB2,...) )commit=y ignore=y Log=test.log
How to build table spaces, build users, and import DMP files in Oracle