Oracle old import export tools (imp/exp).
user doing the import or export should have imp_full_database
and exp_full_database in order to do a import of export on a full
database
Examples
set ORACLE_SID to whatever instance they want the dump from
exp \'sys/mypass AS SYSDBA\' OWNER=USER1 FILE=USER1_2007041101.dmp
create user USER1 identified by pass123
SQL> alter user USER1 quota unlimited on SYSTEM;
User altered.
SQL>
import to another user:
imp \'sys/mypass AS SYSDBA\' fromuser=USER1 touser=USER2 ignore=y commit=y file=/var/exports_20070726/USER1_2007072601.dmp log=./USER12.log
NOTE
if the import hangs run the following:
if ‘Automatic archival Disabled’ run the following:
ALTER SYSTEM ARCHIVE LOG START;
for manual run:
Alter system archive log all;
to update spfile on 9i
create pfile='/tmp/pf' from spfile; (then go edit the /tmp/pf then run the following)
create spfile from pfile='/tmp/pf';
Sometimes when exporting you get a warning about the server
being in one character set and export is being done in another. Then
you might get a bunch of 'questionable statistics exported' warning. If
this is the case, stop the export and set your shell's NLS_LANG to the
same charset as the server. (note that you need a . before the charset)
export NLS_LANG=.AL32UTF8