Oracle: HOW TO CREATE TABLESAPCE
create tablespace datafile ‘c:—–.dbf’ size 200m;
create tablespace datafile ‘c:—–.dbf’ size 200m;
select username,default_tablespace from dba_users;
alter tablespace add datafile ‘PATH’ size 200m;
1. EXPORT: exp system@test owner=test123 file=d:oracleuser.dmp log=d:oracleuserdump.log rows=y statistics=none feedback=100 indexes=y consistent=y compress=n; (for individual tables=table1,table2,…..) 2. IMPORT: imp system@test fromuser=test123 touser=test123 file=d:oracleuser.dmp log=d:oracleuser11.log ignore=y rows=y indexes=y feedback=100;