tanvir ahmed wrote:I don't use XE but I think it should be supporting export and import binaries which should be able to do what you are looking for.
I am newbie in oracle database pls explain in some more detail.
I have same database 11g express edition on two computers at two different locations and want to run same database by taking backup from one compuer and restoring on other computer.
That sounds to me to be the closest answer to the question posted. And perhaps the easiest solution.Stop database, and copy all files to another machine.
To do a proper database clone its better to recreate the controlfile and reset the archive sequence number- leave out the controlfile copy part. In the diag_path location find the trace file under diag/rdbms/$ORACLE_SID/<db_name>/trace it should be the latest ora*.trc file.
select name from v$datafile; ... file1, file2 ... show parameter control ... control_files ... file1 ... alter database backup controlfile to trace [reset logs]; ... show parameter diag; ... diagnostic_dest ... <drive:>|/diag_path