|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Importing problems
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. |
|
#2
|
||||
|
||||
|
Exported the schema without data?
Export it to a SQL file omitting storage clauses. With what tools are you working? |
|
#3
|
|||
|
|||
|
Exported with data to a dmp file using exp, and using imp to import.
|
|
#4
|
||||
|
||||
|
You should really learn how to pose questions, and also how to answer
Quote:
C'mon
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias) Last edited by pabloj : December 4th, 2003 at 04:19 PM. |
|
#5
|
|||
|
|||
|
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 :
(1)Privileges problem (2)User problem (3)NLS_Language 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. |
|
#6
|
|||
|
|||
|
I don't think you can import "backwards" meaning an export file created with 9.2 cannot be imported with 9.0...
|
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Importing problems |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|