Logical Backup - Export Utilitygreenspun.com : LUSENET : DBAzine : One Thread |
while taking Logical Backup thru Export Utility can i take Database structures in ASCII (english like text) format? if yes how? Because by default it writes in binary............
-- Mukesh Moharir (mmoharir@jyotistructures.com), April 19, 2002
Hi,You can use the import utility with the INDEXFILE parameter (see imp help=y) to create a file with the database structure. For example:
exp scott/tiger@ORCL file=exp.dmp log=exp.log owner=SCOTT --this will create a export file with the schema SCOTT
imp scott/tigger@TEST_DB file=exp.dmp log=imp.log SHOW=Y INDEXFILE=STRUCTURE.TXT --this won't import the data, but will show the contents of the export file into the log file (imp.log) and will create a file with the structures (STRUCTURE.TXT).
.
-- Maurilio (maurilio_damasceno@ig.com.br), June 20, 2002.