This content has been marked as final. Show 3 replies
Export schema will load all the data,table and other objects in a dumpfile of a particular schema that you have mentioned.The dump files basically contain ddl commands which get executed by Import Utility.
1) When we say import schema and export schema, what does that exactly mean? I was thinking importing a schema will create similar tables and all is that correct ?
Also Read this
Schema Mode Export :-- http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_export.htm#i1007509
What do you mean by data objects??
2) I created dump files by running expdp command. and imported it using impdp command into another schema on same db. Does this copies only the schema or the data objects too?
If you mean table data then yes.
For importing into different schema you have to use remap_schema
Refer this docs.Search with keyword remap_schema
thanks a lot for clarifying