I know some of you are going to shoot me for this ...... but does Oracle
have an equivalent for Informix's dbchema command ?

TIA




Dirk Moolman
Database and Unix Administrator
Digicare Technologies (HealthCorp)



"People demand freedom of speech as a compensation for the freedom of
thought which they seldom use."


>
The information on this e-mail including any attachments relates to the official business of DigiCare (Pty) Ltd. The information is confidential and legally privileged and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised and as such any disclosure, copying, distribution or any action taken or omitted in reliance on it is unlawful. Please notify the sender immediately if it has inadvertently reached you and do not read, disclose or use the content in any way.
>
No responsibility whatsoever is accepted by DigiCare (Pty) Ltd if the information is, for whatever reason, corrupted or does not reach its intended destination. The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of DigiCare (Pty)Ltd, except where the sender has specifically stated them to be the views of DigiCare (Pty) Ltd.
>

In message <mailman.273.1138090593.740.informix-list@iiug.org>, Dirk
Moolman <DirkM@caretech.co.za> writes
>I know some of you are going to shoot me for this ...... but does Oracle
>have an equivalent for Informix's dbchema command ?

How about you ask in an Oracle newsgroup or forum?

--
Surfer!
Email to: ramwater at uk2 dot net

>I know some of you are going to shoot me for this ...... but does Oracle
>have an equivalent for Informix's dbchema command ?

The short answer for an Oracle direct equiv of dbschema is 'No'.

But there are many ways to get the same sort of information that
dbschema provides, this can be done using tools suc as Toad or
depending on what you actually want, and which oracle version you are
using, there is a package called DBMS_METADATA which you can get the
DDL necessary to create most objects. All of the information that would
be required to provide the similar output to dbschema is held in system
tables and can be extracted. You can generate SQL to recreate
users/roles etc etc. There are many scripts out there on forums such as
DBA-Village which would provide scripts to do this.

<continue> ....

......also, there is of course the way to extract DDL from imp(ort) for
tables and indexes etc....This can be very fiddly, which is probably
why they brought in the dbms_metadata package in later (9i) version...

Hello Dirk,

gointo obstacle enterprice manager,
goto table you want
right click -->> show object ddl

See you

Superboer

Dirk Moolman schreef:

> I know some of you are going to shoot me for this ...... but does Oracle
> have an equivalent for Informix's dbchema command ?
>
> TIA
>
>
>
>
> Dirk Moolman
> Database and Unix Administrator
> Digicare Technologies (HealthCorp)
>
>
>
> "People demand freedom of speech as a compensation for the freedom of
> thought which they seldom use."
>
>
> >
> The information on this e-mail including any attachments relates to the official business of DigiCare (Pty) Ltd. The information is confidential and legally privileged and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised and as such any disclosure, copying, distribution or any action taken or omitted in reliance on it is unlawful. Please notify the sender immediately if it has inadvertently reached you and do not read, disclose or use the content in any way.
> >
> No responsibility whatsoever is accepted by DigiCare (Pty) Ltd if the information is, for whatever reason, corrupted or does not reach its intended destination. The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of DigiCare (Pty) Ltd, except where the sender has specifically stated them to be the views of DigiCare (Pty) Ltd.
> >

Superboer wrote:
> Hello Dirk,
>
> gointo obstacle enterprice manager,
> goto table you want
> right click -->> show object ddl
>
> See you
>
> Superboer

OEM? Possibly in an older version but not if in 10g.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

Dirk Moolman wrote:
> I know some of you are going to shoot me for this ...... but does Oracle
> have an equivalent for Informix's dbchema command ?
>
> TIA
>
>
>
>
> Dirk Moolman
> Database and Unix Administrator
> Digicare Technologies (HealthCorp)
>
>
>
> "People demand freedom of speech as a compensation for the freedom of
> thought which they seldom use."
>
>
>
> The information on this e-mail including any attachments relates to the official business of DigiCare (Pty) Ltd. The information is confidential and legally privileged and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised and as such any disclosure, copying, distribution or any action taken or omitted in reliance on it is unlawful. Please notify the sender immediately if it has inadvertently reached you and do not read, disclose or use the content in any way.
>
> No responsibility whatsoever is accepted by DigiCare (Pty) Ltd if the information is, for whatever reason, corrupted or does not reach its intended destination. The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of DigiCare (Pty) Ltd, except where the sender has specifically stated them to be the views of DigiCare (Pty) Ltd.

Oracle often seems reluctant to compete with its third-party vendors.
In this case there are many tools, such as ERwin, that do it well and
Oracle provides Designer too. And as theusarools stated it can also
be done using IMP(ort) but I might differ with him on his claim that
it is finicky if I knew what he intended: Finicky not being a technical
term I am familiar with. What I can tell you it works and works well.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

I know that you can "export" a table with the exp command and specify:
schema=y
rows=n

but I don't know if the resulting exported schema is human readable.

But this is really the wrong forum for this question - there are
several Oracle newsgroups to post. Also, if you get a MetaLink
account, you can ask the nice folks at big-O directly.

-- J

Yeah, just found that out whilst installing it onto ubuntu....
great they canned enterprice mgr (it was there in 9.2) and replaced it

by a web interface..... which does not give the schema....

Yikes.

Superboer.


DA Morgan schreef:

> Superboer wrote:
> > Hello Dirk,
> >
> > gointo obstacle enterprice manager,
> > goto table you want
> > right click -->> show object ddl
> >
> > See you
> >
> > Superboer
>
> OEM? Possibly in an older version but not if in 10g.
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan@x.washington.edu
> (replace x with u to respond)

> Oracle often seems reluctant to compete with its third-party vendors.

ahum a simple thing called dbschema should be part of any database
so you can recreate stuff etc.

regarding competing... well i heard storys about Obstacle going to
customers of their partners and offered them what their partner was
offering...... so reluctant.... i do not think so.... sorry.

for what it's worth i thought the em console thing in 9.2 was a
nice tool to use... the webbie thingie; haven't found the
dbschema button yet.... and my opninion: that webbie thingie ain't
good.

Informix's ISA is far far better.


Superboer.