Home » RDBMS Server » Server Utilities » what happened when cange data during take export (oracle 10g windows)
what happened when cange data during take export [message #277307] Mon, 29 October 2007 08:43 Go to next message
allahmorad
Messages: 18
Registered: June 2006
Junior Member
Hi,

when i take export full database i need 2 hour
my question is : during this time , if 100 users works
with database, and maybe change some tables , for example

insert into table1(col1) values('hello')

when exp finished . is 'hello' row in dump file ?
if table1 and table2 have relationship?


best regards
allahmorad

Report message to a moderator

Re: what happened when cange data during take export [message #277310 is a reply to message #277307] Mon, 29 October 2007 08:55 Go to previous messageGo to next message
Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Read Export documentation about the CONSISTENT parameter.

Report message to a moderator

Re: what happened when cange data during take export [message #277311 is a reply to message #277307] Mon, 29 October 2007 08:55 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Do a exp help=y and look at the keyword CONSISTENT.

Report message to a moderator

Re: what happened when cange data during take export [message #277312 is a reply to message #277311] Mon, 29 October 2007 08:58 Go to previous message
Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
/forum/fa/1940/0/

Report message to a moderator

Previous Topic: change datafile address
Next Topic: sql loader problems
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 14 17:55:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.