12-05-2012
Expdp error logging:
i am using expdp in korn shell to export tables from oracle. What i dont know is how to capture any errors if my expdp fails.
I am looking for some options like Spool where i can write the error into a file and return the location of that file to my calling script in case of errors. Please help me on this. TIA!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi, just wriiten a sh script and as my script will try to log into another server to delete some files but when i run , it keeps on saying that my files do not exist. It seems to refer to my local directory instead. Below is my script :
FTP_HOST=ip_number
FTP_USER="user password"
... (1 Reply)
Discussion started by: blueberry80
1 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I am writing a shell script (ksh, solaris 5.8).
Script is X.sh
variables declared:
LOGFILE=X.log
the script is removing a file:
/usr/bin/rm "$DUMP_FILE1".Z >> $LOGFILE
If I kick off the script from the command line as follows:
./X.sh > X.con 2<& 1 (1 Reply)
Discussion started by: niamh
1 Replies
3. UNIX for Dummies Questions & Answers
Yesterday evening my server appeared to fall over. I couldn't copy (scp) files to it, and I couldn't SSH to it either. Every time I tried, it just gave me this message:
Read from remote host <IP ADDRESS>: Connection reset by peer
Connection to <IP ADDRESS> closed.
I got in this morning, and... (4 Replies)
Discussion started by: Dave Stockdale
4 Replies
4. Post Here to Contact Site Administrators and Moderators
Hi Everyone. First, I want to thank all of you for letting me participate in this great group.
I am having a bit of a problem.
After I get an email from a responder, I login to make my reply.
In the mean time I get another response by email from another member, I go to reply to them and I... (6 Replies)
Discussion started by: Ccccc
6 Replies
5. Solaris
no shell error is coming whn i am trying login as users. i acn loggin as root
thanks (1 Reply)
Discussion started by: sunnybee
1 Replies
6. Shell Programming and Scripting
Afternoon ladies and gents,
I am trying to create a simple script to remove a certain file from a user's network profile location. The removal works ok, but in the interest of overkill I would like to add a simple error detection (such as file doesn't exist or permission denied)
Currently, it... (2 Replies)
Discussion started by: hateborne
2 Replies
7. Shell Programming and Scripting
Hi there,
I'm encountering problems on an AIX system when using following in my script.
find . -name *.edi -type f -exec sh -c 'scp {} $user@$server:$path || exit 5; mv {} $sent || exit 7' \;
the error i get is following
find: 0652-018 An expression term lacks a required... (4 Replies)
Discussion started by: Kerberos
4 Replies
8. 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
9. UNIX and Linux Applications
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.
# expdp system/oracle directory=test dumpfile=Prodfb20150311.dmp logfile=Prodfb20150311.log FULL=y
Export: Release 11.2.0.1.0 -... (2 Replies)
Discussion started by: clerck
2 Replies
10. Linux
When unlocking a Linux server's console there's no event indicating successful logging
Is there a way I can fix this ?
I have the following in my rsyslog.conf
auth.info /var/log/secure
authpriv.info /var/log/secure (1 Reply)
Discussion started by: walterthered
1 Replies
LEARN ABOUT SUNOS
capture-schema
capture-schema(1m) Application Server Utility capture-schema(1m)
NAME
capture-schema - stores the database metadata (schema) in a file for use in mapping and execution
SYNOPSIS
capture-schema-dburl url-username name- password password-driver a_jdbc_driver [-schemaname name] [-table tablename]* [-out filename]
Stores the database metadata (schema) in a file. You can also use the Sun Java System Studio IDE to capture the database schema. Run cap-
ture-schema as the same database user that owns the tables, so that the -username and -schemaname options are given the same username.
Additionally, you can grant the database user running the capture-schema command the ANALYZE ANY TABLE privilege.
OPTIONS
-dburl JDBC URL expected by the driver for accessing a database.
-username user name for authenticating access to a database.
-password password for accessing the selected database.
-driver JDBC driver classname in your CLASSPATH.
-schemaname name of the user schema being captured. If not specified, the default will capture metadata for all tables from all
the schemas accessible to this user. Specifying this parameter is highly recommended. If more than one schema is
accessible to this user, more than one table with the same name may be captured which will cause problems.
-table name of the table; multiple table names can be specified.
-out output target; defaults to stdout. This parameter corresponds to the schema sub-element of the sun-cmp-mapping ele-
ment in the sun-cmp-mapping_1_1.dtd file.
EXAMPLES
Example 1: Using capture-schema
capture-schema -dburl jdbc:oracle:thin:@sadbuttrue:1521:ora817
-schemaname cantiflas -username CANTIFLAS -password enigma -driver
oracle.jdbc.driver.OracleDriver
asadmin(1M)
Sun Java System Application Server March 2004 capture-schema(1m)