publipolar

Senior Member Hi, I am trying to use NETWORK_LINK option in datapump and import a table from one server to another. I gave the below command: C:>Drivers Marvell 88se9128 Driver there. impdp example/example@db DIRECTORY=DATA_PUMP_DIR NETWORK_LINK=db.legal.regn.net remap_schema=BI:example tables=BI.BI_DIRECT dumpfile=BI.dmp logfile=BI. Emraan Hashmi Mashup Mp3 Song Download 2015. log Got the following errors: ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at 'SYS.UTL_FILE', line 536 ORA-29283: invalid file operation Is this error related to the permission in the OS level (windows 7 in my case)? I manually created the folder 'DATA_PUMP_DIR' in the specified directory path. Though the directory I created (DATA_PUMP_DIR) shows read-only in the general tab of the property, I am able to create files under the folder 'DATA_PUMP_DIR'.

Please let me know how to resolve this issue? Senior Member 1) SQL>select directory_path from dba_directories where directory_name='DATA_PUMP_ DIR'; DIRECTORY_PATH -------------------------------------------------------------------------------- C: users lg123 desktop SQL>grant read, write on directory DATA_PUMP_DIR to example; Grant succeeded.

SQL>select name from v$database; NAME --------- db This shows the directory DATA_PUMP_DIR exists in the db database. 2) C: Users lg123 Desktop DATA_PUMP_DIR>This shows the OS directory 'DATA_PUMP_DIR' exists. 3) I am the owner of the machine. I have full permission in the OS level. I have attached the image which shows I have full permission on the OS level.

Hi all, when I try to update some columns that don't have the data I receive ORA-02000: lack of UNUSED keyword error. Keep in mind that file tnsnames.ora forms 11g is under $ORACLE_INSTANCE/config.

• Attachment: (Size: 27.10KB, Downloaded 430 times). Senior Member lg123 wrote on Mon, 11 February 2013 14:24 1) SQL>select directory_path from dba_directories where directory_name='DATA_PUMP_ DIR'; DIRECTORY_PATH -------------------------------------------------------------------------------- C: users lg123 desktop The above says the datapump directory is C: users lg123 desktop, but Quote: C: Users lg123 Desktop DATA_PUMP_DIR>This shows the OS directory 'DATA_PUMP_DIR' exists. Shows that the case does not match. I do not know how Windows handles case, but in unix, they are different. Additionally, there is no point in having a directory called DATA_PUMP_DIR, because that is NOT where the output will go. I think you misunderstand what an Oracle directory is. DIRECTORY_PATH is the actual directory, not a path in which you create an OS directory under.

Senior Member Yes, you are right. The database is on some other machine, not in my machine. I am trying to use my machine to access the database which sits in some other machine. For this purpose, I use oracle client. My aim is to load the tables from source database to the destination database.

I need to prepare a script which can load the tables every night at 12. That is why I want to use datapump tool. Since I have only read access to the source database, I want to use NETWORK_LINK option and try to load the tables without doing anything in the source database(like creating dump files, etc.). Should the directory be only on the server? Now the major issue is that I am not able to connect to the source database because I do not have the tnsentry to keep it in my tnsnames.ora file local to my machine. I have been provided only LDAP details.