Dear All,
I have few DB objects(20 tables, 20 sequences, 2 object types and a procedure, to be precise) in one schema and i want to migrate them(copy them) to another schema.
what would be best way, so that i don't miss any indexes, constraints, data,Triggers etc., i.e.,everything related to those objects.
If i use CTAS, it seems the indexes and all won't come.
Also, how can i copy sequences, so that the value continues in the new schema from where it was, in the old schema.
Kindly help.