473,811 Members | 3,298 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Generate DDL of Schema

fahimghauri
8 New Member
Hi,

How can DDL of a schema be generated in oracle, as in DB2 db2look command provide the facility?
I can generate DDL from enterprise manager, but that create generate DDL of a single table and also does not generate DDL of Foreign keys.

Regards,
Fahim
Jul 2 '08 #1
3 9337
debasisdas
8,127 Recognized Expert Expert
you can export the schema and recreate the entire schema from the dump using import.
Jul 2 '08 #2
fahimghauri
8 New Member
you can export the schema and recreate the entire schema from the dump using import.
thanks Debasisdas,

But this is not desired. I need only SQL commands (DDL) as a text file,if its possible.

As I said, It is possible to create DDL of a single table, if it is possible for a single table then it must be possible to generate for all tables, I guess through some API or database procedures. But I am unable to find until now. . .

Regards,
Fahim
Jul 3 '08 #3
amitpatel66
2,367 Recognized Expert Top Contributor
Check out for DBMS_METADATA package for getting the DDL of the tables
Jul 3 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

0
2421
by: Almoni | last post by:
Hi, I have a few .xsd files that include each other in the following way: <!-- lets call the main schema file AA.xsd and it includes BB.xsd inside it --> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified">
0
1748
by: Robert Jacobson | last post by:
Hi, I have a number of classes in one assembly. I'd like to use XSD.exe to generate a schema for just one class ("Parse Rules") and its nested child classes. Is there an attribute that will allow me to do this? I tried running XSD on the entire assembly, with the plan to delete the unnecessary classes from the .xsd afterwords. However, it complained that a certain class "cannot be serialized because it does not have a default...
1
1429
by: M Ali | last post by:
Hi, I am in a situation where I don't have access to an xml, say "original.xml". But I do have the schema for it and an XSLT transformation on it that would create a new xml from "original.xml" called "transform.xml". What i need is the schema for the "transform.xml". I could generate the schema from the xml if I had "transform.xml". But I don't have access to "original.xml" so I cannot apply the transform to get
3
5265
by: rehveli | last post by:
Isn't it possible to generate .cs files from schemas, where one schema imports another, and both have the same namespace? If a.xsd and b.xsd have namespace "MyNameSpace", and in b.xsd I do <xsd:import namespace="MyNameSpace" schemaLocation="a.xsd"/> and run "xsd.exe /c a.xsd b.xsd", xsd.exe errors out with "Error: A schema with the namespace 'MyNameSpace' has already been added."
2
6935
by: PeterW | last post by:
I have an xml file from which I want to generate an xsd schema and at a later stage a cs class. The xml file has a mix of defined namespaces and also an empty namespace. These are defined as follows: <silcn:silcn xmlns:silcn='http://silcn.org/200309' xmlns='http://xmlprobe.com/200312'> it contains an element <report> off the root and also a separate <Silcn:report> again off the root.
1
4186
by: comic_rage | last post by:
Hi, I am writing code with C# to generate xml schema, however, the following code generate a UTF-16 in the first line. This will create some problems. How can get the code/missing what part of the code in C# to generate a first line with UTF-8 instead of UTF-16? Thanks, public XmlSchema CreateSchemaRoot()
8
6463
by: Phil Lee | last post by:
I'm sure this is possible but I just can't see how to do it. I want to add schemas to my solution and have C# classes automatically generated from them. I can see how to generate typed DataSet's with the MSDataSetGenerator custom tool. Is there something similar for simple schemas? Regards Phil Lee
2
3541
by: Nathan Wiegman | last post by:
Hi, I am using the XSD utility to generate schemas for some of the classes that we serialize in our project. Everything works fine and dandy until I try and create a schema for a class that spans assemblies. For example, if I have a class named "ClassB" that resides in "ClassB.exe" and uses stuff (classes) from "ClassC.dll", I would expect the following to work:
2
1579
by: andy gilman | last post by:
When I generate an xsd *schema* I get something like : <?xml version="1.0" encoding="utf-16"?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:element name="AccountsReceivable"> .... but I want to have the following, and don't know how to achieve it
0
1386
by: mmaslar | last post by:
Can Visual Studio ('05 or '08) generate a WSDL file with an external Schema file? eg. Instead of placing the schema within the WSDL file, generate it in a separate XSD file? In other words... When I browse to the WSDL (http://localhost:4444/WebService1.asmx?wsdl) the schema is inline. I'd like it to be external. Any way of doing that? Yes I know the net result is the same, but this WSDL will become the "contract" for other systems -- and an...
0
9727
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9605
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10647
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10398
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9204
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6889
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5692
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3865
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3017
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.