[askdba] Re: Database Link between different Oracle versions

  • From: "Pepling, Todd C." <tpepling@xxxxxxx>
  • To: "'askdba@xxxxxxxxxxxxx'" <askdba@xxxxxxxxxxxxx>
  • Date: Tue, 23 Nov 2004 10:23:06 -0500

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> desc toddtest1
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)


> -----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 <kurt_mckeown@xxxxxxxxxxxx> wrote:
> Can anybody tell me if it is generally save to use
> database links between different versions of Oracle,
> e.g. between and or between
> and 
> 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.

Other related posts: