I am getting an error when using "Export: Release 22.214.171.124.0 - Production" on "AIX 126.96.36.199" and connecting to a remote database with version "Oracle Database 11g Enterprise Edition Release 188.8.131.52.0 - 64bit Production". I have tried many different options but the latest command that I ran is:
exp Userid=id/password@db TABLES=myschema.mytable file=mytable.dat log=mytable.log compress=y INDEXES=N
I am not using expdp for some specific reasons but this Export works on smaller tables whereas this has > 100,000 records. Also there is ample space on the landing directory.
Any help is appreciated.
This is the bug. Read this
OERR: EXP 3 "no storage definition found for segment(%lu, %lu)" [ID 21599.1]
It also happens When trying to export an object, all associated objects are exported as well. If one of the indexes is owned by a user and the exporting user does not have permissions on that index object the export fails.
Edited by: TSharma on Feb 7, 2013 11:47 AM