Tedi,
First, let me clarify that when you say, "I want to import only one DB...", in Oracle terminology, you probably mean, "I want to import only one User/schema/owner...". Any one of those terms would be appropriate in Oracle terms. The term "DB" (database) as you used it would be appropriate in just about any non-Oracle database vendor environment.
Now, to import just one Oracle user/schema/owner, you can specify which owner to import from your "full database export" dump file by using these parameters on your Import ("imp") command line:
Code:
imp ...fromuser=<source_schema> touser=<target_schema>...
replace <source_schema> and <target_schema> with the appropriate Oracle usernames for your situation.
The "..." mean other import parameters may go here.
Let us know if this resolves your need.
![[santa] [santa] [santa]](/data/assets/smilies/santa.gif)
Mufasa
(aka Dave of Sandy, Utah, USA)
@ 04:26 (02Dec04) UTC (aka "GMT" and "Zulu"),
@ 21:26 (01Dec04) Mountain Time