oracle创建表空间、用户、赋予权限、数据导入

oracle创建表空间、用户、赋予权限

1. 创建表空间

CREATE TABLESPACE test
    DATAFILE '/home/oracle/app/oracle/oradata/helowin/SQJW_DATA.dbf' SIZE 2048M
    AUTOEXTEND ON NEXT 1024M MAXSIZE 20480M;

2. 创建用户

CREATE USER test IDENTIFIED BY test_202105;

3. 赋予用户权限

GRANT CONNECT, RESOURCE ,DBA TO test;

4. 测试

SELECT * from all_tables where owner='test';

5. 修改密码

alter user test identified by test_202105;

6. 当前连接数

select count(*) from v$process; 

7. 查看最大连接数

select value from v$parameter where name = 'processes'; 

8. 修改最大连接数 为 300

alter system set processes = 300 scope = spfile; 

导入数据

imp test/test_202105@helowinXDB file=/home/oracle/app/oracle/oradata/20210611.dmp
log=load.log TABLES=table_name

imp test/test_202105@helowinXDB file=/home/oracle/app/oracle/oradata/20210611.dmp tablespaces=XQBJGL_NX fromuser=sourcename touser=targetname 

imp test/test file='D:\IdeaProjectsPackageXs\zzjggl.dmp' log='D:\IdeaProjectsPackageXs\IMP0509.log' ignore=y


imp test/test_202105 file='/home/oracle/app/oracle/oradata/20210611.dmp ' ignore=y