NCC搭环境 导数据等等

导入数据

--创建表空间
CREATE TABLESPACE NNC_DATA01 DATAFILE 'D:\Database\oracle\oradata\orcl\nnc_data01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ; 
CREATE TABLESPACE NNC_INDEX01 DATAFILE 'D:\Database\oracle\oradata\orcl\nnc_index01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ; 
--表空间扩展
ALTER TABLESPACE NNC_DATA01 ADD DATAFILE 'D:\oracle\app\Lenovo\oradata\orcl\NNC_DATA02.DBF' SIZE 4096M AUTOEXTEND ON NEXT 32M MAXSIZE 10240M;【扩展表空间】
-- 创建用户
CREATE USER TEST_USER IDENTIFIED BY TEST_USER DEFAULT TABLESPACE NNC_DATA01 TEMPORARY TABLESPACE TEMP QUOTA  UNLIMITED  ON NNC_DATA01;
--授权
GRANT CREATE SESSION TO TEST_USER;
GRANT CREATE TABLE TO TEST_USER;
GRANT CREATE TRIGGER TO TEST_USER;
GRANT CREATE VIEW TO TEST_USER;
GRANT UNLIMITED TABLESPACE TO TEST_USER;
grant read,write on directory DPDIR2 to TEST_USER;
grant connect,dba to TEST_USER;    

　　

--从NCC0918用户导到TEST_USER
impdp TEST_USER/TEST_USER@localhost/orcl directory=dpdir2   dumpfile=NCC200520201014.dmp remap_schema=NCC0918:TEST_USER TABLE_EXISTS_ACTION=REPLACE FULL=Y logfile=NCC200520201014.log; 

　　

 

安装plsql

版本：plsql12

注册信息：

PLSQL Developer 12.0.7 注册码
product code： 4vkjwhfeh3ufnqnmpr9brvcuyujrx3n3le 
serial Number：226959 
password: xs374ca

 

 

实例地址：

https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.ht

 

plsql下载地址

https://www.allroundautomations.com/registered-plsqldev/

 

 

---

 

前端环境搭建

---

 

NCC 2005