| Export/Import [message #73475] |
Fri, 07 May 2004 00:23  |
Hana
Messages: 5
Registered: May 2004
|
Junior Member |
|
|
Can you tell me please, if is it possible to use parameter in Export and Import utility? For example:
exp USER/PASSWORD@CONNECTSTRING FILE=tippmit.dmp LOG=tippmit_exp.log FULL=N OWNER=SPORT ROWS=Y GRANTS=Y INDEXES=Y CONSTRAINTS=Y COMPRESS=N
I want to use a parametr for username, password and connect string - USER/PASSWORD@CONNECTSTRING and for OWNER=SPORT - one script for several users. Platform is Windows NT and database Oracle 8i.
Thanks Hana
|
|
|
|
| Re: Export/Import [message #73484 is a reply to message #73475] |
Mon, 10 May 2004 07:06  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
The Oracle Utilities Users Guide documents all export/import parameters. Look at the following:
USERID=
OWNER=(owner1, owner2, ...)
FROMUSER=(user1, user2, ...)
TOUSER=(user1, user2, ...)
Best regards.
Frank
|
|
|
|
|
|
| Re: Export/Import [message #73494 is a reply to message #73484] |
Tue, 11 May 2004 10:56 |
croca
Messages: 50
Registered: January 2004
|
Member |
|
|
You can also leave username/passwd as blank and let oracle ask you dinamically when executing the export/import utility.
Best regards.
Need to ckeck you RMAN backups? www.otools.com.ar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
