[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>
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 <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 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.
Other related posts:
