Daily Archives: August 5, 2009

alter system set control_files=’path.ctl’,'path.ctl’ scope=spfile; Original post blogged on b2evolution.

desc dba_tablespaces or desc v$tablespace; Original post blogged on b2evolution.

desc dba_temp_files or desc v$tempfile; Original post blogged on b2evolution.

select tablespace_name,sum(bytes/1024/1024/1024) from dba_free_space group by tablespace_name Original post blogged on b2evolution.

alter database datafile ‘c:\—–.dbf’ resize 1024m; Original post blogged on b2evolution.

create temporary tablesapce tempfile ‘c:\——.dbf’ size 200m; Original post blogged on b2evolution.

create tablespace datafile ‘c:\—–.dbf’ size 200m; Original post blogged on b2evolution.

select username,default_tablespace from dba_users; Original post blogged on b2evolution.

alter tablespace add datafile ‘PATH’ size 200m; Original post blogged on b2evolution.

1. EXPORT: exp system@test owner=test123 file=d:\oracle\user.dmp log=d:\oracle\userdump.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:\oracle\user.dmp log=d:\oracle\user11.log ignore=y rows=y indexes=y feedback=100; Original post blogged on b2evolution.