Shulou(Shulou.com)05/31 Report--

This article is about how to create oracle tablespaces and how to import dmp files. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

-- Log in with the account authorized by the oracle system

-1. Create user create user u_name identified by "u_password";-- 2. Give permission to grant dba, resource, connect to upright nameholder grant create session to upright namebot grant create table to ubiquitous namebot grant create view to upright namebot grant create tablespace to upright namebot grant unlimited tablespace to upright namebot grant select any table to upright nameberry grant select any dictionary to upright namebot grant to select any dictionary to upright namebot 3. Create a directory dictionarycreate directory directory_name as'D:\ oracleEnv\ Oracle\ product\ 11.2.0\ db\ backup';-- path can be specified by yourself-- 4. Give the directory permission GRANT read,write ON DIRECTORY directory_name TO upright name Mattel 5. Create the tablespace create tablespace table_space_namedatafile 'D:\ oracleEnv\ Oracle\ product\ 11.2.0\ dbhome_1\ oradata\ table_space_name.DBF'size 2500Mautoextend on next 500m maxsize 12000M;-- 6. Modify the tablespace configuration ALTER USER table_space_name DEFAULT TABLESPACE upright name file_id,bytes from dba_data_files where tablespace_name='my_table_space_name';-- 8. Check the tablespace select tablespace_name, file_id,bytes from dba_data_files where tablespace_name='my_table_space_name';-- 9. Import data-simple version of impdp u_name/u_password@ORCL dumpfile=file_path full=y table_exists_action=replace-- Common Edition impdp u_name/u_password@ip_address/space_name directory=my_director full=y dumpfile=my_dmp_file.DMP logfile=my_dmp_file.log table_exists_action=replace Advanced version of impdp u_name/u_password@ip_address/space_name directory=my_director full=y dumpfile=my_dmp_file.DMP logfile=my_dmp_ file.log [remap _ schema=user_1:user_2] [remap_tablespace = table_space_1:table_space_2] [table_exists_action=replace] Thank you for reading! On "how to create oracle tablespaces and achieve dmp file import" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, you can share it out for more people to see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.