Home » Server Options » Streams & AQ » Error creating Streams example - ORA-01729: database link name expected (11gR1)
Error creating Streams example - ORA-01729: database link name expected [message #481053] Fri, 29 October 2010 14:11 Go to next message
lamikam
Messages: 7
Registered: April 2009
Junior Member
Error creating Streams example - ORA-01729: database link name expected


Running 11gR1. Example from doc, "4 Single-Database Capture and Apply Example"

the database name is "11G3". when I run the Step 3 statement below, I get the error below. What am I doing wrong? Thanks!

DECLARE
iscn NUMBER; -- Variable to hold instantiation SCN value
BEGIN
iscn := DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER();
DBMS_APPLY_ADM.SET_TABLE_INSTANTIATION_SCN(
source_object_name => 'hr.employees',
source_database_name => 11G3,
instantiation_scn => iscn);
END;
/


Error at line 1

ORA-01729: database link name expected

ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 742

ORA-06512: at "SYS.DBMS_APPLY_ADM", line 726

ORA-06512: at line 5


Error at line 1

ORA-01729: database link name expected

ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 742

ORA-06512: at "SYS.DBMS_APPLY_ADM", line 726

ORA-06512: at line 5


Re: Error creating Streams example - ORA-01729: database link name expected [message #481054 is a reply to message #481053] Fri, 29 October 2010 14:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
source_database_name => 11G3,

Quotes are missing, I think.

Regards
Michel
Re: Error creating Streams example - ORA-01729: database link name expected [message #481055 is a reply to message #481054] Fri, 29 October 2010 14:19 Go to previous messageGo to next message
lamikam
Messages: 7
Registered: April 2009
Junior Member
Sorry, my bad. It was quoted. I pasted it in wrong. Still get error.
Re: Error creating Streams example - ORA-01729: database link name expected [message #481058 is a reply to message #481055] Fri, 29 October 2010 15:18 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste your session.
Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Previous Topic: Help with Sync capture
Next Topic: DML / DDL Handlers
Goto Forum:
  


Current Time: Fri Mar 29 01:47:32 CDT 2024