var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Exporting tables ?
I have small problem........
I just want to export tables alone from a database and import the same to my database.I dont want other objects like view,storedprocedure,packages and functions to be imported into my database.
Thanx in advance
There exists a parameter-driven oracle-export tool.
Under Oracle-DB 9.2 for Windows the program is called exp.exe and is located in the oracle-home\bin.
For more information see the oracle doc for export/import utility
All Oracle versions (at least since Oracle 7; I "saw" Oracle 5 - can't tell I worked with it really) have export utility (just to make clear that export isn't restricted to Oracle 9.2 and Windows platform).
Of course, it is necessary to read documentation about it to fully understand its capabilities, but - to make a long story short - use the tables parameter to export only tables. For example,
EXP un/pw TABLES=(table1, table2, ..., tablex) FILE=tabexp.dmp
To import the tables, you don't have to list them - simply use
IMP un/pw FILE=tabexp.dmp
Last edited by Littlefoot; 07-06-04 at
Thank you very much.
Infact i am currently using the exp utility only thing i wanted to know was to how to restrict the export only to tables.
What is that i have to do if i have to export all the tables.
Thanx & Regards
I'm afraid you'll have to list them all ... At least I don't know how to avoid it.