exporting schema

[nnemani]

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.

[shawish_sababa]

do you need to keep the diff between dev and prod or do you whant to copy prod on dev no metter what?

[nnemani]

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.

[sreddy]

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

[nnemani]

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.