Home » RDBMS Server » Server Utilities » is it safe to kill full db export? (oracle 9i)
is it safe to kill full db export? [message #488486] Fri, 07 January 2011 16:39 Go to next message
chris32680
Messages: 92
Registered: January 2006
Location: Charlotte
Member
sorry for the miniscule info...i just need a quick yes or no answer.

We started a full db export using exp, and we need to kill it. Is it "safe" to do so? Killing it won't affect the database in any way, right?

$ORACLE_HOME/bin/exp system/xxxxxx BUFFER=140000 FULL=Y FILE=/export/<sid>.exp VOLSIZE=2000M GRANT
S=Y INDEXES=Y COMPRESS=Y

Report message to a moderator

Re: is it safe to kill full db export? [message #488488 is a reply to message #488486] Fri, 07 January 2011 17:05 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Yes. you can always kill the job in OS.
Meanwhile, I would not use compress=Y.

Report message to a moderator

Previous Topic: TKPROF-Cannot open trace file
Next Topic: SQL Loader date mask for the data in the format 02MAR1948:00:00:00.000 OR 24SEP1950:00:00:00.000
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 11:38:06 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.