Home » SQL & PL/SQL » SQL & PL/SQL » oracle utility (oracle 10g)
oracle utility [message #383705] Thu, 29 January 2009 17:52 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #383719 is a reply to message #383714] Thu, 29 January 2009 19:37 Go to previous messageGo to next message
modhiyakomal
Messages: 49
Registered: November 2008
Location: US
Member
And yes oracle utility means i m going to tell about SQL loader.
Thanks
Re: oracle utility [message #383720 is a reply to message #383717] Thu, 29 January 2009 19:38 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #383724 is a reply to message #383705] Thu, 29 January 2009 20:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>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
Re: oracle utility [message #383725 is a reply to message #383723] Thu, 29 January 2009 20:14 Go to previous messageGo to next message
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 Go to previous message
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)
Previous Topic: Dynamic while loop
Next Topic: Forms
Goto Forum:
  


Current Time: Tue Feb 18 01:41:49 CST 2025