Daily Archives: August 7, 2009

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; 3.ADDIND DATAFILE INTO A TABLE SPACE: alter tablespace {tablespace name}add datafile ‘PATH’ size 200m; … Continue reading →

select username,created,account_status from dba_users where username like ‘—–%’ order by created Original post blogged on b2evolution.

create user [username] identified by [password] default tablespace [tablespace name which has free space acc to statement 8] quota unlimited on [same tablespace name]; Original post blogged on b2evolution.