08-10-2017
What is wrong with the oracle community?
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hey all,
I'm trying to locate a good sql forum - similar in nature to this, where I can can get some quick responses to questions I have.
I've tried a few but they are either no longer running - or have one visitor every month.... just wanting to see if anyone uses a forum that is of the... (6 Replies)
Discussion started by: peter.herlihy
6 Replies
2. UNIX for Advanced & Expert Users
Hi ... apologies for posting in this section ... I figured this would be the best place to pose this question - does anyone know a good forum for selling Unix related hardware - I have a handful of HP C3750's that I would like to sell. I am located in Toronto. Thx. (2 Replies)
Discussion started by: krs1
2 Replies
3. AIX
HI All,
Does anyone out there know of any good online tutorials for the basics of routing, gateways, networking with AIX, preferably the more recent versions like 5.2/5.3?
Using commands such as netstat, smit mkroute, etc. to connect to boxes on a network, and load software with networked... (1 Reply)
Discussion started by: jeffpas
1 Replies
4. AIX
Which Forum for IBM Storage production are good? (1 Reply)
Discussion started by: rainbow_bean
1 Replies
5. Solaris
Hi all,
This is a good news for Oracle on Solaris users
Oracle Database 11g Release 2 now available for both SPARC and x86_64 users here (3 Replies)
Discussion started by: h@foorsa.biz
3 Replies
6. Red Hat
I have failed many times on install red hat in virtual machine, can anybody provide the good image file of red hat? (3 Replies)
Discussion started by: wulaishiwo
3 Replies
7. What is on Your Mind?
This forum has been so instrumental in my learning scripting and unix commands that I seriously can't believe it and have been advertising it to everyone I know. I started from almost zero knowledge and within a few months I already feel much less ignorant.
The amount of information and... (7 Replies)
Discussion started by: newbie2010
7 Replies
8. What is on Your Mind?
Today I change the DB and the PHP code and rebuilt the database for similar threads at the end of each post, increasing from a max of 5 to a max of 10 similar threads per post:
More UNIX and Linux Forum Topics You Might Find Helpful
It was quite easy to do:
1. Increased the max size of... (17 Replies)
Discussion started by: Neo
17 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)