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
评论区