Oracle数据库查询表空间位置、创建表空间、创建用户以及数据库导入

-查询数据库表空间位置：

select tablespace_name,file_id,bytes/1024/1024,file_name from dba_data_files order by file_id;

-查询数据库表空间使用情况：

SELECT tablespace_name ,
       ROUND(SUM(bytes) / (1024 * 1024), 2) AS "已分配大小（MB）",
       ROUND((SUM(maxbytes - bytes)) / (1024 * 1024), 2) AS "未分配大小（MB）"
FROM dba_data_files
GROUP BY tablespace_name;

-创建数据库临时表空间：

create temporary tablespace ERP_TEMP
tempfile '/home/oracle/app/oracle/oradata/helowin/ERP_TEMP.dbf'
size 1024m
autoextend on
next 500m maxsize unlimited
extent management local;

-创建数据库表空间：

create tablespace FKS_DATA_TBS
datafile '/home/oracle/app/oracle/oradata/helowin/FKS_DATA_TBS.dbf'
size 1024m
autoextend on 
next 500m maxsize unlimited 
extent management local; 

-创建用户及授权：

-- Create the user 
create user user01 identified by user01
  default tablespace FKS_DATA_TBS
  temporary tablespace ERP_TEMP
  profile DEFAULT
  quota unlimited on FKS_DATA_TBS;
-- Grant/Revoke object privileges 
grant read, write on directory SYS.DATA_PUMP_DIR to user01;
-- Grant/Revoke role privileges 
grant connect to user01;
grant dba to user01;
grant resource to user01;
-- Grant/Revoke system privileges 
grant create synonym to user01;
grant create view to user01;
grant unlimited tablespace to user01;

imp方式导入用户：

imp user01/user01@127.0.0.1:1521/Oracle fromuser=user touser=user01 file="D:\Temp\user.dmp" log="D:\Temp\toUser01.dmp"

数据库导出导入参考：https://blog.csdn.net/weixin_45964650/article/details/115213095