Problem in import & expdp Dump file Post: 302938098

Sponsored Content

Special Forums UNIX and Linux Applications Problem in import & expdp Dump file Post 302938098 by clerck on Thursday 12th of March 2015 03:53:34 AM

03-12-2015

Registered User

Problem in import & expdp Dump file

Hi all,
i face a problem on (oracle database) installed on server Linux i need to export back as dump file, when i try to export give me the below error.

[root@srv1 mohamed]# expdp system/oracle directory=test dumpfile=Prodfb20150311.dmp logfile=Prodfb20150311.log FULL=y

Export: Release 11.2.0.1.0 - Production on Thu Mar 12 09:27:09 2015

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
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

the steps i had made on SQLpluse:

1-CREATE DIRECTORY test AS '/u01/backup/testdump';

GRANT read, write ON DIRECTORY test to system;

clerck

View Public Profile for clerck

Find all posts by clerck

10 More Discussions You Might Find Interesting

1. SCO

XML Import & HTTP Post

this may be very basic to some but all new to me I have an application running on SCO Unix server which issues an HTTP Post request to a server with the results being returned in I.E browser window in XML format I need to import these results into my customers application and dont know how to...

2. Web Development

Confused maybe about MySQL Dump & PHP

Hello. the purpose of my efforts right now are to get a larger script of mine (which the admin told me he'd put into cron for me) to properly back-up my MySQL database. To test out the sql back-up part (before getting the whole script into cron, and having it not work) I wanted to test it. So...

3. Programming

Java import problem

In a default package, there are BankTest.java and package bank wich contains Account.class . // File: BankTest.java import bank.*; public class BankTest { public static void main(String args) { Account account; ... } } Trying to compile BankTest.java,...

4. Shell Programming and Scripting

Mysql import problem

Dear folks, i am importing a database since yesterday that is innodb tablespace, the space of dump file is 4GB, almost 24 pass out it is not yet complete. What should i do to import it fastly. I have disable foreign key check because it have some issues so thats why i am importing it with source...

5. UNIX for Dummies Questions & Answers

Import dump to database

Hi... I have dump in unix machine...How can I this import dump to Oracle database? Many thanks in advance.

6. Shell Programming and Scripting

Zip dump file using expdp:

Hi All, i am using expdp to create a dump file of contents from an oracle table. I want this dump file to be zipped. Is there a way/ option in expdp where the dump file will be automatically zipped when its been created. If not please suggest other methods.

7. UNIX for Dummies Questions & Answers

How to Import dump file with default value for single column?

Hi, I need to import more than 250K of records to another Database(Oracle).But I want particular column value to be changed in the destination table. Is it possible to do this during export or import process with out modifying data from original table.I do not want to run Update manually. ...

8. UNIX for Dummies Questions & Answers

How can I import a particular schema from full dump in Oracle?

Hi All, I have a full oracle dump file that I have exported from a production server. I want to import a specific schema out of the full dump. Is that possible in oracle. What will be the command for that?

9. UNIX and Linux Applications

How to import and dump file to remote Oracle server?

Hi All, I have a linux centos instance which has a dump file. I need to import the dump file to the oracle server which is located at some remote location. I have installed the oracle client on my machine and I am able to connect to the remote oracle server. Now how to import the dump to the...

10. Homework & Coursework Questions

Oracle dump file (del format) import into db2

1. The problem statement, all variables and given/known data: are the oracle dump files compatible to direct import into db2? I already tried many times but it always truncated results. anyone can help/ advice or suggest? 2. Relevant commands, code, scripts, algorithms: exp...

LEARN ABOUT OPENSOLARIS

systemd-importd.service

SYSTEMD-IMPORTD.SERVICE(8)				      systemd-importd.service					SYSTEMD-IMPORTD.SERVICE(8)

NAME

       systemd-importd.service, systemd-importd - VM and container image import and export service

SYNOPSIS

       systemd-importd.service

       /lib/systemd/systemd-importd

DESCRIPTION

       systemd-importd is a system service that allows importing, exporting and downloading of system images suitable for running as VM or
       containers. It is a companion service for systemd-machined.service(8), and provides the implementation for machinectl(1)'s pull-raw,
       pull-tar, import-raw, import-tar, export-raw, and export-tar commands.

       See the importd D-Bus API Documentation[1] for information about the APIs systemd-importd provides.

SEE ALSO

       systemd(1), machinectl(1), systemd-machined.service(8), systemd-nspawn(1)

NOTES

	1. importd D-Bus API Documentation
	   https://www.freedesktop.org/wiki/Software/systemd/importd

systemd 237														SYSTEMD-IMPORTD.SERVICE(8)