First of all, I wish you a Happy New Year to you all
I have been learning most of the stuffs in oracle DB from here. Thanks for that to all.
Recently, I got an original export dump (exp) to import in the database.. and I have imported in the database.
but, some doubts I had about the import.
The export log ended as below: +. . exporting table GILRFILES 17336 rows exported+ +. . exporting table FLY7 0 rows exported+ +. . exporting table KOCHC 19645 rows exported+ +. exporting synonyms+ +. exporting views+ +. exporting stored procedures+ +. exporting operators+ +. exporting referential integrity constraints+ +. exporting triggers+ +. exporting indextypes+ +. exporting bitmap,functional and extensible indexes+ +. exporting posttables actions+ +. exporting materialized views+ +. exporting snapshot logs+ +. exporting job queues+ +. exporting refresh groups and children+ +. exporting dimensions+ +. exporting post-schema procedural objects and actions+ +. exporting statistics+ Export terminated successfully without warnings.*
I executed the below import command: imp userid=JRET/JRET file=F:\oracle\need\SALLOOONI.dmp fromuser=JRET*
The import ended with the below lines: +. . importing table "GILRFILES" 17336 rows imported+ +. . importing table "FLY7" 0 rows imported+ +. . importing table "KOCHC" 19645 rows imported+ Import terminated successfully without warnings.*
My doubt is...
Where are the indexes, synonyms, procedures and functions which are exported in exp dump but they are not visibly displayed in the import. When I executed a command to import index I got the warning stating "This was done by SYS not by you" and an error stating " Already exists'. When I asked one of my friend he said indexes will be imported in imp command when the above imp command is issued.
Is this true..? can some one put some light on this.
Thanks in advance
Edited by: 897910 on Jan 1, 2012 10:44 PM
I will frame the question in simpler way.
If I execute the below command: imp userid=JRET/JRET file=F:\oracle\need\SALLOOONI.dmp fromuser=JRET*
what it would do?
what are the objects imported by the command?
Edited by: Nonuday on Apr 29, 2012 11:25 PM
Dean Gagne wrote:
Any object in the dumpfile owned by T24 would be imported. If it existed, an error would be reported.
Thanks I got the answer. The exp dump had objects like index, view, procedure, etc..
As when they are imported from user JRET from the exp dump which has all the objects and they are imported as well.
Thanks for your input Dean.