December 4th, 2003, 11:04 AM
I'm working with a remote dev team, and I need to send them one of my schemas. I exported the schema to a file, but the dev team is unable to import it into their schema there. I'm a newbie with Oracle, so I'm not even real sure how to troubleshoot this with them. What I do know is that we are running slightly different versions of Oracle (we have 9.2 here, they are running 9.0), but other than that, i don't have much idea.
I'm sure my post here is lacking enough details to get a good answer, but I'm hoping that someone can point me in the right direction in terms of what order things should be done in, common problems that may exist, etc. Thanks in advance for all your help.
December 4th, 2003, 12:49 PM
Exported the schema without data?
Export it to a SQL file omitting storage clauses.
With what tools are you working?
December 4th, 2003, 02:20 PM
Exported with data to a dmp file using exp, and using imp to import.
December 4th, 2003, 05:15 PM
You should really learn how to pose questions, and also how to answer
Last edited by pabloj; December 4th, 2003 at 05:19 PM.
December 6th, 2003, 03:25 PM
Because you did not mention that what kind of problem you are expriencing, I suppose that you might be getting one of the following problem :
I am not sure that will it work for you and not but try it:
imp <username>/<password> file=filename.dmp full=Y ignore=Y
If exporting schema has DBA privileges but importing schema does not, grant the DBA privilege to importing schema or revoke the DBA privilege from exporting schema.
December 6th, 2003, 06:40 PM
I don't think you can import "backwards" meaning an export file created with 9.2 cannot be imported with 9.0...