Ministry of Railways has been changed / revised their Advance Reservation
Period (ARP) to 60 days from May 1, 2013. It was 120 days till April 30,
2013. One way it is good because majority of the travelers cannot plan their
travel in advance of 4months. It will help for the genuine / frequent travelers.
This is also another interesting
question. Suppose if you get a dump from the source database and you are not
aware of the users/schemas present in the dump. If you wanted to see the list
of schemas/users present in the dump file, you can use this method to find out
It is a common
question or doubt which arises when you get a dump file from the source
database without knowing how it is exported. It might be taken using either
conventional exp utility or data pump expdp. If you have the log file along
with the dump file, it is very easy to identify the utility. You just need to
tail the log file and you can identify as mentioned below.
Drop Storage clause
is to deallocate all space from the deleted rows from the table except the
space allocated by the MINEXTENTS parameter in the table. This deallocated
space will move to free space category and it can be used for the other objects
in the tablespace. So in this drop storage clause there would be some space
which is equal to the MINEXTENTS used for the table after
the truncate command execution.