2014年
-
编辑 删除
oracle创建表空间，赋权限给用户
create tablespace FRAMEWORK logging datafile 'D:SoftSetupDiroracleproduct10.2.0oradataorclFRAMEWORK.DBF' size 256m autoextend on next 64m maxsize 1024m extent management local; CREATE USER RONE IDENTIFIED BY RONE DEFAULT TABLESPACE FRAMEWORK; GRANT CONNECT,RESOURCE,DBA TO RONE; impdp RONE/RONE@orcl directory=DATA_PUMP_DIR dumpfile=FRAMEWORK20131220.dmp schemas=RONE select * from dba_directories 查找建表语句sql，以及导入数据的sql，
