连接Oracle:sqlplus / as sysdba
切换到PDB:
alter session set container=ORCLPDB1;
创建表空间:CREATE TABLESPACE KXDB DATAFILE '/opt/oracle/oradata/ORCL/PDBKXDB01.DBF' SIZE 4096M AUTOEXTEND ON NEXT 100M;
CREATE temporary TABLESPACE KXDB_TEMP tempfile '/opt/oracle/oradata/ORCL/PDBKXDB_TEMP.DBF' SIZE 1024M AUTOEXTEND ON NEXT 10M;
创建用户:create user kxdb identified by kxdb123 default tablespace KXDB Temporary tablespace KXDB_TEMP;
授权:grant dba to kxdb;
grant connect to kxdb;
修改密码永久有效:ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
导入数据:
imp kaixunapptest/kaixun2016@orclpdb1 file=/home/oracle/kingsun_20220708_0100.dmp full=y ignore=y