Hi,
I'm new to Oracle Developer tools.
I have created a Database project using Devart Project Template in VS2010 and trying to import all objects from the Oracle database.
Although in the Oracle Wizard project, it asks for importing Indexes and Grants, however when I finish importing, no index or grant is imported.
There are no option available to re-run the wizard after the project is created and re-import the database objects again!
Thanks for your reply,
Mohammad
Oracle Project Wizard does not import all objects
Re: Oracle Project Wizard does not import all objects
Indexes are exported successfully (please check Table/View settings group on DDL Generation Options page of the wizard).myaesubi wrote: Although in the Oracle Wizard project, it asks for importing Indexes and Grants, however when I finish importing, no index or grant is imported.
Users and grant currently cannot be exported with this wizard. As a workaround you can open Security Manager, select required user and run Generate DDL comand from the popup menu. Then include created file into project.
Indeed, there is no such option. You'll need to delete the old project and re-create it again.myaesubi wrote: There are no option available to re-run the wizard after the project is created and re-import the database objects again!
Re: Oracle Project Wizard does not import all objects
Duke wrote:Indexes are exported successfully (please check Table/View settings group on DDL Generation Options page of the wizard).myaesubi wrote: Although in the Oracle Wizard project, it asks for importing Indexes and Grants, however when I finish importing, no index or grant is imported.Users and grant currently cannot be exported with this wizard. As a workaround you can open Security Manager, select required user and run Generate DDL comand from the popup menu. Then include created file into project.Thanks for Reply.
By default Triggers and Indexes are checked to be exported on the Wizard Table/View settings, however upon exporting only Triggers are exported and indexes are notWould guide me to "Security Manager"? Is it in Devart tool or Oracle out of the box tools?Indeed, there is no such option. You'll need to delete the old project and re-create it again.myaesubi wrote: There are no option available to re-run the wizard after the project is created and re-import the database objects again!
I'd checked that indexes were exported before answering. Maybe problem lyes deeper.By default Triggers and Indexes are checked to be exported on the Wizard Table/View settings, however upon exporting only Triggers are exported and indexes are not
Main Menu->Tools->Devart OraDeveloper Tools->Database->Security ManagerWould guide me to "Security Manager"? Is it in Devart tool or Oracle out of the box tools?
Duke wrote:I'd checked that indexes were exported before answering. Maybe problem lyes deeper.By default Triggers and Indexes are checked to be exported on the Wizard Table/View settings, however upon exporting only Triggers are exported and indexes are not
Main Menu->Tools->Devart OraDeveloper Tools->Database->Security ManagerWould guide me to "Security Manager"? Is it in Devart tool or Oracle out of the box tools?
Thank you, as you mentioned there is another issue caused this case. It seems I don't have enough permission to export indexes and grants!