I need to make a schema on dev server same as prod server. Right now the schema on dev server is missing some objects. What is the best way of doing this?
Thanks in advance.
do you need to keep the diff between dev and prod or do you whant to copy prod on dev no metter what?
I dont want to keep dev server different, as I need to test some reports on dev server which needs to have the same schema as prod server.
One more doubt I have is about tablespaces, they are different on dev and prod servers. How can I specify different tablespace name when importing in dev server.
Click Here to Expand Forum to Full Width