Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

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…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
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, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

610 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