We have a prod. database that we export and import into another database daily. This is taking a lot of time. Can we copy the datafile of prod and replace the datafile of the target db with the copy of prod. I'm thinking herte something similar to restoring a db from a physical backup. Would we need the control file as well (but the db names are diff).
Thanks in Advance,