All rights reserved. intelligence agencies claim that Russia was behind the DNC hack? Just e-mail: and include the URL for the page. Email check failed, please try again Sorry, your blog cannot share posts by email. %d bloggers like this: SQLAJ Sharing what I know about Databases Menu AboutMy PresentationsTraining Videos Search for:
Recreate the ASCII-table as an ASCII-table Why would two species of predator with the same prey cooperate? Contents 1 Start using datapump export 2 Create database directories 3 Let's try the export again 4 Import into another database 5 Network import 6 Invoking from PL/SQL 7 More info Sort an array of integers into odd, then even At what point is brevity no longer a virtue? SELECT * FROM user_tab_privs WHERE table_name = ‘DATAPUMPDIR'; As we can see I now have access to use this directory.
Generalization of winding number to higher dimensions What are the benefits of an oral exam? Refer here for more in detail. exported "SCOTT"."BIGEMP" 145.2 MB 3670016 rows . . Expdp Unable To Open The Log File It still gives the same error and I am very sure the directories exists.
SQL> create database link old_scott connect to scott identified by tiger using 'orcl.oracle.com'; Database link created. Ora-39087 Directory Name Is Invalid Windows Create a directory for dump file set and log file. Null check OR isEmpty Check Are there any rules of thumb for the most comfortable seats on a long distance bus? imported "SCOTT"."T1" 0 KB 0 rows Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC Processing
I do not get it. Ora-22930: Directory Does Not Exist PS: Oracle introduced a default directory from 10g R2, called DATA_PUMP_DIR, that can be used: SQL> SELECT directory_path FROM dba_directories WHERE directory_name = 'DATA_PUMP_DIR'; DIRECTORY_PATH -------------------------------------------------------------------------------- /app/oracle/product/10.2.0/rdbms/log/ Let's try the export Replaced: CREATE OR REPLACE DIRECTORY dpump_dir AS 'C:\Data\SID' With: CREATE OR REPLACE DIRECTORY dpump_dir AS 'C:\Data\SID\' share|improve this answer answered Feb 12 '15 at 23:28 Ken 411 add a comment| up share|improve this answer answered Sep 19 '13 at 8:28 David Aldridge 37.8k63867 Yes on the server,the reason is have no privilege with the directory,and has bee solved,thank you –Dolphin
Ora-39087 Directory Name Is Invalid Windows
SQL> grant create database link to new_scott; Grant succeeded. All legitimate Oracle experts publish their Oracle qualifications. What does the expression 'seven for seven thirty ' mean? A single word for "the space in between" Is it a security vulnerability if the addresses of university students are exposed? Udi-00014: Invalid Value For Parameter, 'directory'
more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Do you mean a directory within the database or within the filesystem? How to change "niceness" while perfoming top command? Keeping windshield ice-free without heater Is there any way to take stable Long exposure photos without using Tripod?
Connected to: Oracle Database 12c Release 126.96.36.199.0 - 64bit Production ORA-39002: invalid operation ORA-39070: Unable to open the log file. Ora-39154: Objects From Foreign Schemas Have Been Removed From Import SQL> conn new_Scott/tiger Connected. Theres a directory in "~/Desctop/import" containing the dump file.
The main surprise comes with an undocumented fact that Oracle's default Data Pump directory object, DATA_PUMP_DIR, cannot be used for data pump export and import.
Why are there no Imperial KX-series Security Droids in the original trilogy? All rights reserved. Forum FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders Who's Online What's New? Ora-39002 Ora-39070 Ora-29283 Ora-06512 Ora-29283 oracle backup share|improve this question edited Sep 19 '13 at 8:10 a_horse_with_no_name 198k27252328 asked Sep 19 '13 at 7:53 Dolphin 64831336 add a comment| 3 Answers 3 active oldest votes up
Data is exported across a database link and imported directly into the target database. All rights reserved. exported "SCOTT"."NEWOBJECT1_T" 0 KB 0 rows . . now what?
Then all you do is execute your export utility created in the previous post.