Loading into Synonyms

You can load data into a synonym for a table during a direct path load, but the synonym must point directly to either a table or a view on a simple table. Note the following restrictions:

  • Direct path mode cannot be used if the view is on a table that has user-defined types or XML data.

  • In direct path mode, a view cannot be loaded using a SQL*Loader control file that contains SQL expressions.