0 Replies Latest reply: Jun 26, 2012 4:03 PM by user9152952 RSS

    import from other schemas other than default

    user9152952
      Hi,

      I defined a source metadata location to an Oracle database. The user used to connect to the DB itself has no objects. I need to import tables and views from other schemas in the source Oracle database. It that possible using the same user that was used in creating the metadata source location? Or, does one need specific one-to-one connection established as separate source metadata locations in order to import tables and views from other schemas?

      In other words, is one user/password to a database sufficient to import tables and views from other schemas?

      Thanks!