Database Administration (MOSC)

MOSC Banner

ORA-1033 (Windows Server 2012)

edited Oct 22, 2015 5:48PM in Database Administration (MOSC) 11 commentsAnswered ✓

BTW, I posted this problem a while ago, but cannot find the thread again (Is there a way to locate one's own started discussions?)

The last thing I did was (in SQLPLus):

drop user someone cascade;

alter tablespace someone_data offline;

drop tablespace someone_data including contents and datafiles cascade constraints;

drop tablespace someone_temp;

commit;

rem exec DBMS_LOCK.SLEEP(60);

quit;

At system level (Admin rights):

net stop OracleServiceOrcl

del c:\app\kuku\oradata\orcl\someone_temp.dbf

del C:\app\kuku\oradata\orcl\someone_data.dbf

net start OracleServiceOrcl

C:\Bench\Oracle\import\  set ORACLE_SID=ORCL

C:\Bench\Oracle\import\ sqlplus system/password

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center