ITPub博客

首页 > 数据库 > Oracle > 10gCR-Chapter 26 External table

10gCR-Chapter 26 External table

原创 Oracle 作者:mlh9906 时间:2009-04-27 16:49:25 0 删除 编辑

You can use the external table feature to access external files as if they were tables inside the database. When you create an external table, you define its structure and location within Oracle. When you query the table, Oracle reads the external table and returns the results just as if the data had been stored within the database. But because the data is outside the database, you do not have to be concerned about the process for loading it into the database—a potentially significant benefit for data warehouses and large databases.

你可以使用外部表特性去访问OS上的其它文件,好像他们就是数据库中的表一样。当你建立一个外部表时,你在oralce中定义它的结构和位置。当你查询这个表时,oracle读取外部表,并且像不同表一样返回数据。你不必因为数据是存储在数据库之外的,而考虑数据装载入数据库的过程--对数据仓库和大型数据库来说是潜在的意义重大的好处。

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/146865/viewspace-1021352/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 关于over()
全部评论

注册时间:2009-04-27

  • 博文量
    11
  • 访问量
    13101