What is an Oracle external table
This article introduces the relevant knowledge of "what is the Oracle external table". In the operation of actual cases, many people will encounter such a dilemma. Next, let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!
Summary
Oracle external table is to map the data outside the oracle system to the table in oracle, or to dump the data in oracle to the external table. It is very easy to exchange data with oracle using the external table operating system. External tables can only use the select function, which does not take up oracle storage space.
How do I use external tables? 1. Create or replace directory XXX as'/ path/xxx': create an oracle directory. XXX is the logical name of the directory.'/ path/xxx' is the actual absolute path of the oracle server operating system. You need to pay attention to the correct representation of different operating system paths. The syntax for creating an external table defines the relevant parameters of the external table through the organization external clause. 1.oracle_loader external table, often used to load operating system files into the oracle table. Create table T_XXX (col1 type,col2 type,....) Organiztion external (type oracle_loader-default directory XXX in oracle_loader way-here is the oracle directory access parameter created above-parameter definition (recoders delimited by newline-external data source record segmentation symbol (newline) logfile 'xxx'-log file name or nologfile badfile' xxx' -error message file name or nobadfile fields terminated by' '- Field separator reject rows with all null fields) location (' xx-*.csv')-the file name of the external data source You can use the wildcard character *) reject limit ulimited This is the end of the content of "what is the external Oracle Table". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!
