Oracle建立表空间和用户
--表空间CREATE TABLESPACE sdtDATAFILE 'F:\tablespace\demo' size 800M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; --索引表空间CREATE TABLESPACE sdt_IndexDATAFILE 'F:\tablespace\demo' size 512M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; --2.建用户create user demo identified by demo default tablespace demo; --3.赋权grant connect,resource to demo;grant create any sequence to demo;grant create any table to demo;grant delete any table to demo;grant insert any table to demo;grant select any table to demo;grant unlimited tablespace to demo;grant execute any procedure to demo;grant update any table to demo;grant create any view to demo;?
- --导入导出命令?????ip导出方式：?exp?demo/demo@127.0.0.1:1521/orcl?file=f:/f.dmp?full=y??
- exp?demo/demo@orcl?file=f:/f.dmp?full=y??
- exp sihui/123@192.168.xxxxxx file=E:\sampleDB.dmp? owner=(sihui)imp?demo/demo@orcl?file=f:/f.dmp?full=y?ignore=y??