| QueryBased Import ??? [message #55550] |
Thu, 30 January 2003 23:50  |
Suresh
Messages: 189
Registered: December 1998
|
Senior Member |
|
|
Dear All,
One of My production database is runnig under Oracle9i.Sometimes I need to restore data from the backup dump.For this I used to import the required tables into temp user and whatever info I required that I get from Temp user. Can anyone let me know that Is there any other method to import the required info from dump file directly.
Thanks,
Suresh
|
|
|
|
| Re: QueryBased Import ??? [message #55553 is a reply to message #55550] |
Fri, 31 January 2003 03:24  |
Manish Deshmukh
Messages: 16
Registered: January 2003
|
Junior Member |
|
|
You have to follow the same method as u r doing.Beacuse
if u try to import it directly it will give the error
object already exists as that table will be present in
ur database,also u cannot give the ignore option during
import as it will append all ur data in the exisiting table and the records will be duplicated.
Regards
Manish Deshmukh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
