Home » RDBMS Server » Server Administration » Re: Truncate all tables in database-- in short remove all the data.
Re: Truncate all tables in database-- in short remove all the data. [message #51551] Thu, 30 May 2002 04:45
Grant
Messages: 578
Registered: January 2002
Senior Member
That is the way to do it. For unix I run this query:

set pagesize 0
set linesize 79
set heading off
set feedback off
set echo off
set verify off

spool remove.sh
select 'rm ' || name from v$controlfile;
select 'rm ' || member from v$logfile;
select 'rm ' || name from v$datafile;
spool off
!chmod +x remove.sh

I then shut it down and run remove.sh. I then remove the admin directory and any associated files in $ORACLE_HOME/dbs. I also remove the entry in the oratab file.

For windows just run Database Assistant and do a remove.

Report message to a moderator

Previous Topic: Truncate all tables in database-- in short remove all the data.
Next Topic: logging users off 11i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 26 06:36:23 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.