how can export user tables structure only

Posted on 2004-08-13
Medium Priority
Last Modified: 2012-05-05
how can export user tables structure only not data
Question by:rehman_job
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

sapnam earned 80 total points
ID: 11798759
you can use the rows=n parameter

for a table
exp userid=scott/tiger tables=emp rows=n file=c:\emp.dmp

for the user
exp userid=scott/tiger rows=n file=c:\emp.dmp

Expert Comment

ID: 11799193
You can use the same rows=n parameter to avoid exporting table data.
Exp <User> File=<Path> [Tables=(<Names>)] [Rows=N] [Log=<Path>]


Expert Comment

ID: 11806940
my dear friend

its very simple, u can either use the export command or use can use SQL script to generate the table creation script

just dot he following

1. c:\set oracle_sid=<database name>
2. exp
3. follow the steps which is user interactive.

in one of the options it will ask whether table data to be exported. its default value is Y, just change to N.

or using sql u can have ur table creation script. b ut i suggest that u go for the export command which will also include all constraints,triggers if any for a table.

there u r u have the structure alone.


Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question