Hi All
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.
Printable View
Hi All
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.
PROD
1)exp system/****
buffer=65536
owner=sch_user
consistent=y
DEVT
2)imp sysem/****
buffer=65536
fromuser=sch_user
touser=sch_user
ignore=y
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.