OUTLN schema import oddity
- From: Kevin Lidh <kevin.lidh@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 10 Feb 2006 10:50:07 -0700
We have a production system in which we created 12 stored outlines. So if
you log in as outln you can say: select count(*) from ol$ and get 12. When
I do an export, I see this:
> exp outln file=test.dmp rows=y
Export: Release 9.2.0.4.0 - Production on Fri Feb 10 09:26:32 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Password:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining
options
JServer Release 9.2.0.4.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user OUTLN
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user OUTLN
About to export OUTLN's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export OUTLN's tables via Conventional Path ...
. . exporting table OL$ 12 rows exported
. . exporting table OL$HINTS 904 rows exported
. . exporting table OL$NODES 11 rows exported
> ....< ~~ truncated for e-mail brevity
Export terminated successfully without warnings.
Then when I import, I see this:
> imp outln file=test.dmp full=y ignore=y
Import: Release 9.2.0.4.0 - Production on Fri Feb 10 10:12:24 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Password:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8MSWIN1252 character set (possible charset conversion)
export client uses WE8MSWIN1252 character set (possible charset conversion)
. importing OUTLN's objects into OUTLN
. . importing table "OL$" 12 rows imported
. . importing table "OL$HINTS" 904 rows imported
. . importing table "OL$NODES" 11 rows imported
Import terminated successfully without warnings.
But when I do a select count(*) on our test system, I get this:
> select count(*) from ol$;
COUNT(*)
----------
9
And there are only 678 hints as well. I've tried moving the table to a
tablespace outside of SYSTEM (which is only 4% full), granting "dba" to
OUTLN, setting quota to unlimited on SYSTEM to OUTLN, used consistent=y on
the export and it always comes out the same. No errors on import but only 9
records. To make things more confusing for me, I imported into a different
schema and got all 12 records. Has anyone ever seen this? I'm stumped.
I'm not seeing any errors in the alert log either (or trace files
generated).
Other related posts:
