how to import data over network [message #624952] |
Mon, 29 September 2014 06:39  |
 |
x-oracle
Messages: 380 Registered: April 2011 Location: gujarat
|
Senior Member |
|
|
i have two database on two different different system
one database is live db
another its test db on another machine.
I Have .dmp file on my live db using expdp.now i want to use this live db .dmp file on my test db for importing some table from this live db .dmp file.. i have create one directory on my live db server i want to use this directory created on live db server on my test db database.i donot want to copy this my live db dmp file on my test db .but i directly waant to use this my live db .dmp file on my test db can you help me in this.
...
[Updated on: Mon, 29 September 2014 06:50] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: how to import data over network [message #645236 is a reply to message #645235] |
Tue, 01 December 2015 03:41   |
 |
x-oracle
Messages: 380 Registered: April 2011 Location: gujarat
|
Senior Member |
|
|
thanks
yeah but so many time we have to import table from our live environment to test environment for testing purpose.that time we copy and past this whole dumpfile from live database to test database its take to much time.so this is a best way.i do so many steps but this oracle document id UTL_FILE on Windows NT (Doc ID 45172.1) help me and must import its os username must be same on both database.so here we use administrator user on livedb and testdb so its succeed. another thing its password of this both username must be same on both server.
michel you told me
Quote:Either transfer the file, either do it using NETWORK option.
If you don't want to do it in these ways then don't do it.
but its possible i follow this link also
http://dba.stackexchange.com/questions/59781/accessing-shared-folder-using-oracle-database
and oracle document id (Doc ID 45172.1
[Updated on: Tue, 01 December 2015 03:49] Report message to a moderator
|
|
|
|
|
|
Re: how to import data over network [message #645240 is a reply to message #645238] |
Tue, 01 December 2015 04:10  |
gazzag
Messages: 1119 Registered: November 2010 Location: Bedwas, UK
|
Senior Member |
|
|
There is another important point regarding computer security that often gets overlooked: not only is it provided to prevent malicious damage, it is also to safeguard against accidental damage.
|
|
|