| Vish |
Posted: Apr 25, 2008 08:33:54 AM |
Total Post: 7
Joined: Jan, 2007
|
Please let me know how to do Import and Export through .ini file.
I mean what type of parameter should I give in .ini file. |
|
|
arun |
| Posted: Apr 25, 2008 12:37:53 PM | |
|
Total Post: 28
Joined: Sep, 2007
|
Can u pls explain your requirment with some more details?
|
|
|
|
|
Murtuja |
| Posted: Apr 26, 2008 08:52:52 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
".INI" file is called parameter file and parameter file can have any extension.
This is the example of usage:
exp parfile='c:\parafile.txt'
parafile.txt will have these lines
FILE="C:\testqry.DMP"
LOG="C:\exp_testqry.log"
TABLES=('SCOTT.EMP')
You can get more information about different parameters by "exp help=y" command.
|
|
|
|
|
Vish |
| Posted: Apr 27, 2008 02:12:59 AM | |
|
Total Post: 7
Joined: Jan, 2007
|
My requirement is that in Oracle parameter file I want to define Import and Export parameter file. I don't want to use Exp utility for import or export. This question was asked in interview
|
|
|
|
|
Mohammed Taj |
| Posted: Apr 27, 2008 09:35:50 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
...I don't want to use Exp utility for import or export...
YOu can't do it without using EXPORT/IMPORT utility.
There is two possiblity either you understood wrongly or interviewer asked wrong question about export/import.
|
|
|
|
|
Amjad Ali |
| Posted: Apr 27, 2008 10:46:43 AM | |
|
Total Post: 13
Joined: Apr, 2008
|
Dear Friends....
Is the interview mean to ask about the
SPFILE =
parameter where by we can start database with spfile located at non default location...
Thanks and Regards...
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |