Oracle 导入导出数据.docx

Oracle basic knowledge for DICreate tablespace for database:ORCLLog on ORCL with SQL Plus: usename: ?system@orcl; password: ******Create tablespace with command below:SQL create tablespace sztest logging datafile C:\TS\sztest.DBF size 500M autoextend on next 10M maxsize 500M extent management local;?Check SZTEST.DBF file is in C:\TSGet tablespace list:SQLselect tablespace_name from dba_data_files;Add user to ORCLSQL?create user sztest identified by talend;SQL?grant resource,connect,RECOVERY_CATALOG_OWNER to sztest;SQL?alter user sztest quota unlimited ON sztest;SQL?alter user sztest default tablespace sztest;Get User list;SQLselectt username, default_tablespace from dba_users;Import Oracle db dumpImport with the command below:{Oracle Home Folder}\BINimp system/talend@orcl file=C:\Oracle11Dump\EXPDAT.dmp?tablespaces=sztest?fromuser=talend touser=sztest ignore=y log=c:\test.log?system/talend@orcl: {dbauser}/{password}@database?file=C:\Oracle11Dump\EXPDAT.dmp: Oracle dump file;?fromuser=talend: source user in dump;(can omit it, if target tablespace name is same as source tablespace name)?touser=sztest: target user in database;(can omit it, if target tablespace name is same as source tablespace name)tablespaces=sztest: ?target tablespace;(can omit it, if target tablespace name is same as source tablespace name)Query the imported tables;Export db to Oracle dumpExport with the command below:{Oracle Home Folder}\BINexp system/talend@orcl file=C:/talend.dmp owner=sztest direct=y log=exp.log?system/talend@orcl: {dbauser}/{password}@database?file=C:\talend.dmp: Exported Oracle dump file;?owner=sztest: Data of which user you want to export in dump;Delete tablespaceSQL?DROP TABLESPACE sztest INCLUDING CONTENTS AND DATAFILES;Delete UserSQL?DROP USER sztest CASCADE;Others...??