Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 68931

For questions about the Oracle Data Pump Import (invoked with the impdp command). Use together with the [oracle] tag.

4
votes
Well you can stop the job and make changes in the table and later continue the job either skipping the current object or not. Demo: [oracle@localhost]$ impdp jay/password directory=dp_dir tables … > alter table imptest modify name varchar2(20); Table altered. SQL> exit [oracle@localhost]$ impdp jay/password attach=SYS_IMPORT_TABLE_01--- you can get job name from log file. Import …
answered Oct 11 '16 by JSapkota
4
votes
Data Pump utilities are installed automatically during the installation of Oracle Database. It should be working without any issues as long as the environment variables(PATH, ORACLE_HOME) are set prop …
answered Oct 4 '16 by JSapkota
4
votes
During the impdp process, it doesn't import indexes, in fact it runs number of CREATE INDEX statements. There could be various reasons of slow index creations such as inefficient PGA memory … the following query to check the status of the job. select * from dba_datapump_jobs; Join dba_datapump_sessions with v$session_wait to know whether the impdp session is waiting for some resources. Check alert log for possible error/warning messages. …
answered May 1 '17 by JSapkota
3
votes
If you run export command against live database without parameters like flashback_scn or flashback_time which ensures consistency during the export, then this can be an expected behavior because these …
answered Jan 21 '17 by JSapkota
2
votes
One way to find the cause of ORA errors is to use oerr tool by Oracle. In the error stack the top most is the application error which is followed by other secondary errors. For example, the ORA-3900 …
answered Sep 30 '16 by JSapkota
2
votes
You can drop export/import job using the following command First of all find the name of the job table under 'DataPump>Import Jobs or Export Jobs'. Use the drop command to drop that table by the us …
answered Feb 29 '16 by JSapkota