Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
export database without export
- Thread starter lelo25
- Start date
SantaMufasa
Technical User
Lelo,
If you disclose your objective, perhaps we can suggest a solution besides your using TOAD. If you use "ROWS=N" in your exp command, then that supresses the data output. Then, if you "imp indexfile=<filename>..." then it produces a text file containing the SQL DDL for both indexes and tables. From there, you can edit the file (I use globabl changes) to remark out the storage parameters.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA @ 16:05 (14May04) UTC (aka "GMT" and "Zulu"), 09:05 (14May04) Mountain Time)
If you disclose your objective, perhaps we can suggest a solution besides your using TOAD. If you use "ROWS=N" in your exp command, then that supresses the data output. Then, if you "imp indexfile=<filename>..." then it produces a text file containing the SQL DDL for both indexes and tables. From there, you can edit the file (I use globabl changes) to remark out the storage parameters.
Mufasa(aka Dave of Sandy, Utah, USA @ 16:05 (14May04) UTC (aka "GMT" and "Zulu"), 09:05 (14May04) Mountain Time)
- Status
Similar threads
- Locked
- Question
- Locked
- Question