gudii9
asked on
Toad option to generate schema DDL script
I am using toad to connect to oracle 10g. I want to generate DDL script of entire schema/user say XYZ. I used to see the option earlier ie yesterday as in screenshot named 'ToadOption1' under
Database--->Export--->Gene rate Schema Script.
Now today I cannot see that option any more as in screenshot named 'ToadOption2'. How can i see the above option to 'generate schema script'. Can you please tell me step by step navigation for that to come. I am logging as same schema/user all same not sure why i am not able to see now. I am not sure what i did different today compared to yesterday.Please advise. Any resources, links, ideas, navigation steps highly appreciated. Thanks in advance.
ToadOption.bmp
ToadOption2.bmp
Database--->Export--->Gene
Now today I cannot see that option any more as in screenshot named 'ToadOption2'. How can i see the above option to 'generate schema script'. Can you please tell me step by step navigation for that to come. I am logging as same schema/user all same not sure why i am not able to see now. I am not sure what i did different today compared to yesterday.Please advise. Any resources, links, ideas, navigation steps highly appreciated. Thanks in advance.
ToadOption.bmp
ToadOption2.bmp
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am granting all privileges to user/schema using command
grant all privilege to schema/user with ADMIN OPTION.
Please advise.