Home » RDBMS Server » Server Utilities » is there any utility in oracle
icon7.gif  is there any utility in oracle [message #297533] Fri, 01 February 2008 04:40 Go to next message
Messages: 47
Registered: January 2008
all i have some questions..in my mind
1)is there any utility in oracle to load and unload datas or for that we have to write control files??
2)wht does util file does?
can anyone plzz help me out

Re: is there any utility in oracle [message #297538 is a reply to message #297533] Fri, 01 February 2008 04:50 Go to previous messageGo to next message
Messages: 20849
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If your database version supports them, you could use the external tables feature as well.
UTL_FILE is used in PL/SQL programs to read and write operating system files.

Both external tables and UTL_FILE can be researched if you ./fa/1681/0/
Re: is there any utility in oracle [message #297539 is a reply to message #297533] Fri, 01 February 2008 04:51 Go to previous message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ load: sql*loader, unload:sql*plus
2/ utl_file: read/write to file

http://otn.oracle.com/pls/db102/db102.federated_search to search in Oracle documentation.
Hope you will never come here with this kind of questions.


[Updated on: Fri, 01 February 2008 04:51]

Report message to a moderator

Previous Topic: Problems setting up Dumpfile Location
Next Topic: Export and Import
Goto Forum:

Current Time: Sat Oct 22 12:00:11 CDT 2016

Total time taken to generate the page: 0.09292 seconds