This content has been marked as final. Show 3 replies
Export and import utilities are already installed in an XE database - you do not need to install them again
is there any way to veryfiy.
Hi,1 person found this helpful
Out of curiosity Just went through the script in question
Many objects are created when you run catexp.sql, so you can open catexp.sql(<oracle_home>\server\rdbms\admin) file and verify the objects in the scripts are already available in your database if its available the script has already been run.
You can find an insert statement at the end of the above script with "EXPORT_VIEW_VERSION', Querying the database_property table gives you EXPORT_VIEW_VERSION
select * from database_properties where PROPERTY_NAME = 'EXPORT_VIEWS_VERSION'
Don't know yet some other ways to verify ;)