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
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT DEBIAN
gcstar
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)