Database DataWarehousing (MOSC)

MOSC Banner

ORA-01729 trying to import database objects

edited Sep 9, 2011 1:22AM in Database DataWarehousing (MOSC) 2 commentsAnswered
hello,I'm new DataWahahouse user.
I have just installed it and i'm trying to connect to the source database to import metadata.
Data Warehouse 11gR2 (linux)
Source Database 11gR1 (linux)

Warehouse Builder (XP virtual Machine)

I have done this:
- Create a database location using OCI connection type.
- Test connection Successful.
- Define a database connection using this location.
- Import Databas objects....
SQL Exception
Persistent Layer Error: SQL Exception..
Class Name: CacheMediator
Method Name: getSQLResult
Persistent Layer Error Message: ORA-01729
Database Link expected

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center