please help to ******** some concepts about Oracle Export/Import

[wchuang]

Hi, all:
could you please kindly help me to ******** the following concepts about Oracle Export/Import:
1. "Oracle Export can be done while the exported DB is open.
Therefore, Oracle Export can be used as an alternative On-line Hot backup"
Is this correct??
2. When using Oracle Export to export the "Full DB", instead of export to one big .dmp file,
how can we export to several smaller .dmp files with the same size (ex:1GB each)??
3. " in a DB with inconsistant Database files, we can export the entire DB and then import it back. Oracle will then see these Database files as consistant"
Is this true?? and how come after export and import Oracle will treat them as consistant??

thank you very very much for your help!!

wayne

[pando]

1. export can be done when db is open, it´s not an alternative backup method
2. look export filesize parameter, or split command if you are using linux/unix
3. No, because export is not a proper backup method

[snashte]

1. "Oracle Export can be done while the exported DB is open.
Therefore, Oracle Export can be used as an alternative On-line Hot backup"
Is this correct??

>> NO. Oracle Provides logical and physical backup mode. Export belong to the logical back and the hot backup belong to Physical one.
Export can not be considered as alternative to the physical backup because

1. incase of your db crash u will have to recreate the database
2. time take to import is much higher than that of hot backup.
3. U can not go for point in time recovery.

When using Oracle Export to export the "Full DB", instead of export to one big .dmp file,
how can we export to several smaller .dmp files with the same size (ex:1GB each)??

>> u can use FILESIZ parameter to restrict this

3. " in a DB with inconsistant Database files, we can export the entire DB and then import it back. Oracle will then see these Database files as consistant"
Is this true?? and how come after export and import Oracle will treat them as consistant??

>> NO. This is not True