Hi All,
I am using 10g. i like to duplicate an schema. Example: i have scott schema which has emp, dept tables. i want to create ABC user(similar to scott) which has all the objects of scott like emp, dept tables. so ABC user will work independent. Later, i need to compare these two schema's.
Is there any command or query to do this? Is there any utility or tool to achieve this? or do we need to export the schema and change the users names then import?. Is there any utility to compare these two schema's to identify the difference? Could you please tell me the steps.
Suggestions are welcome. Thanks in advance.