| Problem with IMP utility .... [message #188742] |
Mon, 21 August 2006 07:11  |
frank.svs
Messages: 162
Registered: February 2006
|
Senior Member |
|
|
Hi Team,
Small problem.
I created one user say "demo". Initially i've taken schema bkp of scott user.
as follows .
exp scott/tiger@<service-name> file=scott.dmp log=scott.log
It expoted 4 tables i.e BONUS,DEPT,EMP,SALGRADE
Now, i imported this dump file into newly created user accout "demo". as follows
imp system/pwd@<service-name> file=scott.dmp log=imp.log fromuser=scott touser=demo
Successfully the 4 tables got imported without any warnings.
Now the actual problem,
Now i connected to scott and made 2 modifications
One is i created a new "Sample" with some data.
secondly i added one more column "newcol" to EMP table as follows
SCOTT >alter table emp add newcol varchar2(20) default 'testing';
Now again i taken a fresh exp but this time rows=n
exp scott/tiger<service-name> file=scott2.dmp log=scott2.log rows=n
Now i tried to apply these changes to my "demo" user.What is happening is that, the new table
is getting created with no data. that's fine but my EMP table is not getting modified.is there any
problem with ignore=y
This is stmt i've given
imp system/pwd@<service-name> file=scott2.dmp log=imp2.log fromuser=scott touser=demo ignore=y
But why my EMP table is getting modified.I dont mind even if i loose my data for the tables which
have been modified "structure-wise"
Can anyone pls help me.
Regards,
franky
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
