Export/Import issues

From: MW <mwolski_at_poczta.fm>
Date: Fri, 27 Jan 2006 09:47:44 +0100
Message-ID: <drcmng$eeg$1@sunflower.man.poznan.pl>

Hi,

Oracle Database 9.2 on Solaris

I perform daily database export (exp) with the following parameters CONSISTENT=Y
TABLESPACES=users,others
DIRECT=y
RECORDLENGTH=65535
LOG=/home/backup/hotbackup/oracle-exp/export/expcumul.log FILE=/home/backup/hotbackup/oracle-exp/export/expcumul.dmp

Everything seemed fine to me, but one day I had to restore the selected schema from this export. And it turned out that that the tables contain old and invalid data. I was confused and did the following test: I took the table XXX in the SCOTT schema, which contained initially one row. I added 2 rows and commited changes: SQL> select * from xxx;
NAME

---

a
b
c
Then nightly export was done and in the export log I can read that 3 rows of XXX table have been exported (correct). The following day I performed import of the SCOTT schema: LOG=./data/scott.log
FILE=/home/backup/hotbackup/oracle-exp/home/people/services/oradata/exports/export/expcumul.dmp FROMUSER=SCOTT
TOUSER=SCOTT_ARCH
FEEDBACK=100
RECALCULATE_STATISTICS=y
After this table XXX in the SCOTT_ARCH schema contained only one initial row:
SQL> select * from xxx;
NAME

---

a

MW Received on Fri Jan 27 2006 - 02:47:44 CST