Todd, I did not get your point. Sorry. If I understood correct you mean to say that you can execute DDL, then It will come under the security banner, How you create the link and by which user and what authorities you had given to that user who is using a link, If you have a public link then there is cost you have to under stand, it is not a link issue it is a security issue and a DBA's knowledge issue. I hope I am clear now. Nisar Tareen "Pepling, Todd C." <tpepling@xxxxxxx> wrote: Actually you can execute DDL over a DB link. Here's an example for a db link I named TODD: SQL> exec dbms_utility.EXEC_DDL_STATEMENT@todd('create table toddtest1 as select * from dba_users where 1=0'); PL/SQL procedure successfully completed. Elapsed: 00:00:01.08 SQL> SQL> desc toddtest1 ERROR: ORA-04043: object toddtest1 does not exist SQL> desc toddtest1@todd Name Null? Type ----------------------------------------------------- -------- ------------------------------------ USERNAME NOT NULL VARCHAR2(30) USER_ID NOT NULL NUMBER PASSWORD VARCHAR2(30) ACCOUNT_STATUS NOT NULL VARCHAR2(32) LOCK_DATE DATE EXPIRY_DATE DATE DEFAULT_TABLESPACE NOT NULL VARCHAR2(30) TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30) CREATED NOT NULL DATE PROFILE NOT NULL VARCHAR2(30) INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30) EXTERNAL_NAME VARCHAR2(4000) SQL> > -----Original Message----- > From: Nisar Tareen [mailto:ntareen@xxxxxxxxx] > Sent: Tuesday, November 23, 2004 8:56 AM > To: askdba@xxxxxxxxxxxxx > Cc: dba Group > Subject: [askdba] Re: Database Link between different Oracle versions > > > Kurt, > > The links dose not effect the structures of database, they > only help you to view / update or retrive the data and the > security issue is the user's responsibilty, So the links > should be safe and add on help for a hetrogenious database > environment. > > Nisar Tareen > > Kurt McKeown wrote: > Can anybody tell me if it is generally save to use > database links between different versions of Oracle, > e.g. between 9.2.0.1. and 9.2.0.5 or between 9.2.0.1. > and 10.1.0.2? > > I couldn't find an official statement about that > aspect in the Oracle documentation. > > Thanks, > Kurt > > ===== > ----------------------------------------------------------- > > Find local movie times and trailers on Yahoo! Movies. > http://au.movies.yahoo.com > > > > --------------------------------- > Do you Yahoo!? > The all-new My Yahoo! - Get yours free! > > This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. --------------------------------- Do you Yahoo!? Meet the all-new My Yahoo! ? Try it today!