. . exporting table BS221
EXP-00008: ORACLE error 1403 encountered
ORA-01403: no data found
Encountered when I export dynamic table in production during application is active.
Did some research, but doesn't match to my case. List the relevant URL below.
http://space.itpub.net/?uid-33600-action-viewspace-itemid-266420
Second thought, since it is dynamic data. I should give it 2nd try. (CONSISTENT=Y is used in the PAR file)
I succeed when I export the table again.
Popular Posts
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
I have one PT env using storage sync for database sync. Thought need to re-register DB after DB refresh, so unregister and register again....
-
Encountered this problem during import data from 9i to 10g database. Table structure was already laid out. . . importing table &...
-
SQL> select * from dba_data_files where tablespace_name='TESTBS'; FILE_NAME ...
-
[symptoms] orarac2poc:ORCL2:/home/oracle> . ./oms_agent_env orarac2poc:ORCL2:/home/oracle> $AGENT_HOME/bin/emctl start agent Oracl...
-
As I have CPU issue with physical standby database in previous post, I have to remove it before I have the solution. In 12c Enterprise Man... -
after rounds of recovery testing, I believer there are tons of obsolete files in FRA. There are some stubborn datafile copy can't be de...
-
Oracle collects Active Session History (ASH) statistics (mostly wait statistics for different events) for all active sessions every second f...
-
RMAN> show all; RMAN configuration parameters for database with db_unique_name ORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # de...
-
I hit the error when using RMAN duplicate command to create a physical standby database, with purpose of using same directory structure in...