In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Servers >
Share
Shulou(Shulou.com)06/02 Report--
1. Oracle import backup file steps:
1. Copy the backup file of the database: 123.DMP to the dpdump folder under the oracle installation directory
For example, my path is: d:\ app\ administrator\ admin\ orcl\ dpdump
Log in to sqlplus in your PLSQL Developer or directly under cmd, and do the following
two。 Create tablespace db123.dbf
Create tablespace db123 datafile'D:\ app\ administrator\ admin\ orcl\ dpdump\ db123.dbf' size 500m
Reuse autoextend on next 10m maxsize unlimited extent management local autoallocate permanent online
Specifies that the initial size of the tablespace is 500m, and that the size of each increase after the tablespace is full is 10m.
3. Create a user
Create user + username + identified by + password + default tablespace + tablespace name
-- user, password specify tablespace
4. Authorize the user
Grant connect,resource,dba to user_name
-- authorize the user to user_name.
Connect and resource are built-in roles of the two systems and are juxtaposed with dba.
DBA: has all privileges, is the highest privilege of the system, and only DBA can create the database structure.
RESOURCE: users with Resource permissions can only create entities, not database structures.
CONNECT: users with Connect permission can only log in to Oracle, cannot create entities, and cannot create database structures.
5.cmd runs the following import statement
-- Import database files
Impdp user_name/pwd@orcl dumpfile=123.DMP log=db123.log
Restore the backup file 123.DMP to the user_name user and create a log file called db123.log named db123
2. Oracle exports backup files:
Expdp user_name/pwd@orcl dumpfile = xxx.dmp
-- exports all objects under the user user_name, specifying that the exported backup file name is xx.dmp. The default location of the exported backup files is in the dpdump folder under the oracle installation directory
Third, how to query how many libraries there are?
Plsql developer or sql plus input
Select name from v$database
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.