oracle utility [message #383705] |
Thu, 29 January 2009 17:52  |
modhiyakomal
Messages: 49 Registered: November 2008 Location: US
|
Member |
|
|
Hi All,
can anybody tell me 'is Oracle utility and Oracle scheduler are part of oracle pl/sql or DBA?'
if i want to do job in Oracle PL/SQL then should i prepare myself for oracle utility and oracle scheduler?
please help me
Thanks
|
|
|
Re: oracle utility [message #383714 is a reply to message #383705] |
Thu, 29 January 2009 19:30   |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
What?
What is Oracle "utility"
Pl/sql is a programming language. A DBA is a person. I guess neither "utility" (whatever that is) nor the scheduler can be part of a person.
I suggest you should prepare yourself to read the Documentation and the Forum Guide
|
|
|
Re: oracle utility [message #383717 is a reply to message #383705] |
Thu, 29 January 2009 19:36   |
modhiyakomal
Messages: 49 Registered: November 2008 Location: US
|
Member |
|
|
sorry i had used wrong word,
database utility- oracle import export
AND
not dba but are these part of database administration?
Sorry for inconvenience.
|
|
|
|
Re: oracle utility [message #383720 is a reply to message #383717] |
Thu, 29 January 2009 19:38   |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Well, the CAN be part of database administration.
They can also be part of application development.
|
|
|
Re: oracle utility [message #383721 is a reply to message #383705] |
Thu, 29 January 2009 19:44   |
modhiyakomal
Messages: 49 Registered: November 2008 Location: US
|
Member |
|
|
Thanks,
i got it. but a person who is working on PL/SQL should have knowledge about it? or if have knowledge of it is beneficial for one?
A person who want to enter in PL/SQL related job then what knowledge they should have?
|
|
|
Re: oracle utility [message #383723 is a reply to message #383721] |
Thu, 29 January 2009 20:02   |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
They should definitely know about SQL*Loader, since that knowledge is needed when you want to import flat files into the database, either through SQL*Loader itself or via external tables, which use the same basic syntax for control files.
|
|
|
|
Re: oracle utility [message #383725 is a reply to message #383723] |
Thu, 29 January 2009 20:14   |
modhiyakomal
Messages: 49 Registered: November 2008 Location: US
|
Member |
|
|
Thanks ThomasG,
Means A one should have idea about overview of Sql loader, but if i dnt have coding knowledge, then that will not cause any bad impression right?
The information provided by you will definitely help me.
Thanks.
|
|
|
Re: oracle utility [message #383771 is a reply to message #383724] |
Fri, 30 January 2009 00:59  |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
BlackSwan wrote on Fri, 30 January 2009 03:13 | >And yes oracle utility means i m going to tell about SQL loader.
Starting with V10 SQL Loader could be considered obsoleted,
because of External Table is a superior replacement which can be access via plain SQL
|
I disagree here.
SQL Loader has one big advantage over external tables, and that is (server) security.
For external tables, the database has to have access to the files to be loaded, which means that either a port needs to be open on the database server to copy/scp/whatever the file to the db-server, or there has to be a shared file(-system).
To use SQL Loader however, we only need the one port that is open anyway (tns, mostly 1521 or 1526)
|
|
|