-
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
Reddy,Sam
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|