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
Old 03-12-2015
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;
 

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... (1 Reply)
Discussion started by: ccarcher
1 Replies

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... (12 Replies)
Discussion started by: jzacsh
12 Replies

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,... (0 Replies)
Discussion started by: Luke Bonham
0 Replies

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... (2 Replies)
Discussion started by: learnbash
2 Replies

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. (2 Replies)
Discussion started by: agarwal
2 Replies

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. (8 Replies)
Discussion started by: qwertyu
8 Replies

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. ... (6 Replies)
Discussion started by: GOVINDARAJ.M
6 Replies

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? (6 Replies)
Discussion started by: Palak Sharma
6 Replies

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... (3 Replies)
Discussion started by: Palak Sharma
3 Replies

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... (3 Replies)
Discussion started by: Sonny_103024
3 Replies
GCSTAR(1)							Linux User's Manual							 GCSTAR(1)

NAME
GCstar - Personal collection manager SYNOPSIS
gcstar [-u UPDATE-OPTIONS] [-x EXECUTE-OPTIONS] [FILENAME] DESCRIPTION
GCstar is a Gtk2 program used to manage personal collections. OPTIONS
Without any option, it will open FILENAME if specified or the previously opened file. There are also two groups of options. UPDATE-OPTIONS -u, --update Tell GCstar to look for available updates -a, --all Update all components -c, --collection Update collection models -w, --website Update plugins to download information -i, --import Update plugins to import data -e, --export Update plugins to export data -l, --lang Update translations -n, --noproxy Don't ask for a proxy EXECUTE-OPTIONS -x, --execute Enter non-interactive mode -c, --collection MODEL Specify the collection type -w, --website PLUGIN Specify the plugin to use to download information -i, --import PLUGIN Specify the plugin to use to import a collection -e, --export PLUGIN Specify the plugin to use to export the collection -f, --fields FILENAME File containing fields list to use for import/export -o, --output FILENAME Write output in FILENAME instead of standard output --download TITLE Search for the item with TITLE as name --importprefs PREFERENCES Preferences for the import plugin --exportprefs PREFERENCES Preferences for the export plugin Preferences for import/export plugins are specified using this schema Key1=>Value1,Key2=>Value2 ENVIRONMENT
HOME Used to define following variables if needed XDG_CONFIG_HOME Where configuration files should be stored. If not defined: $HOME/.config XDG_DATA_HOME Where some data will be stored. If not defined: $HOME/.local/share BUGS REPORTING
To report bugs, please use this forum: http://forums.gcstar.org/viewforum.php?id=4 AUTHORS
Tian <tian@c-sait.net> http://www.gcstar.org/ GCstar 17 August 2006 GCSTAR(1)
All times are GMT -4. The time now is 02:48 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy