Someone might have a better suggestion, but the following will work.
Once you have copied (inserted) the rows you want to keep into the new
table, then you can "truncate" the data in the original table. Next,
insert the records back into the original table from the new table.
Next, delete the new table.
Next, analyze the original table.
-----Original Message-----
From: Reddy S. Kadasani
[mailto:oracledba-ezmlmshield-x64327222.[Email address protected]
Sent: Wednesday, May 10, 2006 8:00 AM
To: LazyDBA Discussion
Subject: Oracle Export Error
Hi,
I am trying to export my oracle database to a dump file using the
following export command. I created the database using an import from an
existing dump file. But exporting it out causes an error. Any help will
be appreciated.
Exp test/[Email Address Removed] file= C:\textdb.dmp full=y
Export: Release 9.2.0.6.0 - Production on Wed May 10 09:46:50 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character
set
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully
Thanks
-RK
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page