| Data file modification date [message #405042] |
Tue, 26 May 2009 03:08  |
linuxos
Messages: 31
Registered: April 2009
|
Member |
|
|
I'm new in managing and designing oracle database.
After I performed some DDL/DML on the tablespace (e.g. create table, insert, update), I found that the datafile's modified date in OS is not changed. Only those redo log files and archived log files were changed.
Does it mean the data file was allocated enough space (not extended), and the file was opening or online fI/O processing?
But after I deleted a table, I found the date is modified. Why?
Thanks!
|
|
|
|
|
|
| Re: Data file modification date [message #405059 is a reply to message #405052] |
Tue, 26 May 2009 03:48  |
linuxos
Messages: 31
Registered: April 2009
|
Member |
|
|
|
After I issued "COMMIT" after performing insert/update/delete/create table, etc., how can I know the data are written into the data files? Rather than using "SHUTDOWN IMMEDIATE", should I run "ALTER SYSTEM SWITCH LOGFILE" or something else?
|
|
|
|
|
|
|
|
| Re: Data file modification date [message #405093 is a reply to message #405069] |
Tue, 26 May 2009 05:57 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
| Quote: | That means I can export the data online without shutting down the database.
|
If "export" means Oracle export, you cannot export if the database is down. Export is like any other program, so if data are committed it sees them otherwise it can't.
| Quote: | But for user-managed backup, I still have to shutdown it to copy the data files.
|
You can do it online if you are in archivelog mode and put the tablespace in backup mmode.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
