I need to move selected tables from one schema to another schema within
the same database. The tables I need to move all start with the same
prefix (abc_sometablename). Say there are 200 tables out of 1000 that I
want to move. Is there an easy way to do this?
Thanks!
Ron
--
Please see
, 2003 12:14 PM
To: Multiple recipients of list ORACLE-L
I need to move selected tables from one schema to another schema within
the same database. The tables I need to move all start with the same
prefix (abc_sometablename). Say there are 200 tables out of 1000 that I
want to move. Is there an easy
head so exercise care when running it.
-Original Message-
Sent: 04 August 2003 16:14
To: Multiple recipients of list ORACLE-L
I need to move selected tables from one schema to another schema within
the same database. The tables I need to move all start with the same
prefix
] 04.08.2003 18.14 Uhr
I need to move selected tables from one schema to another schema within
the same database. The tables I need to move all start with the same
prefix (abc_sometablename). Say there are 200 tables out of 1000 that I
want to move. Is there an easy way to do this?
Thanks!
Ron
for both.
Allan
-Original Message-
Sent: Monday, August 04, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
I need to move selected tables from one schema to another schema within
the same database. The tables I need to move all start with the same
prefix (abc_sometablename). Say
Bugger. I missed the schema bit didn't I.
Never mind, back to the drawing board ...
Mike
-Original Message-
Sent: 04 August 2003 16:14
To: Multiple recipients of list ORACLE-L
I need to move selected tables from one schema to another schema within
the same database. The tables I
Title: RE: Move selected tables
I thought the tables were changing their ownership (schema) not the address (tablespace)
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email
, August 04, 2003 12:14 PM
To: Multiple recipients of list ORACLE-L
I need to move selected tables from one schema to another schema within
the same database. The tables I need to move all start with the same
prefix (abc_sometablename). Say there are 200 tables out of 1000 that I
want to move
tables afterwards assuming you have
space for both.
Allan
-Original Message-
Sent: Monday, August 04, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
I need to move selected tables from one schema to another schema within
the same database. The tables I need to move all start
]
Sent by: cc:
[EMAIL PROTECTED] Subject: Move selected tables
selected tables
I need to move selected tables from one schema to another
schema within
the same database. The tables I need to move all start with the same
prefix (abc_sometablename). Say there are 200 tables out of
1000 that I
want to move. Is there an easy way to do this?
Thanks!
Ron
recipients of list ORACLE-L
Subject: Move selected tables
I need to move selected tables from one schema to another
schema within
the same database. The tables I need to move all start with the same
prefix (abc_sometablename). Say there are 200 tables out of
1000 that I
want to move
To: Multiple recipients of list ORACLE-L
I need to move selected tables from one schema to another schema within
the same database. The tables I need to move all start with the same
prefix (abc_sometablename). Say there are 200 tables out of 1000 that I
want to move. Is there an easy way to do
, August 04, 2003 12:14 PM
To: Multiple recipients of list ORACLE-L
Subject: Move selected tables
I need to move selected tables from one schema to another
schema within
the same database. The tables I need to move all start with the same
prefix (abc_sometablename). Say there are 200
Hi!
Right - but it is quite easy to use the dynamic SQL already illustrated in
an earlier email reply (eg below) to capture the entirety of the DDL for
a
suite of tables, and transpose the whole lot into a new schema. In fact, I
am doing this sort of thing repeatedly, as our users areas are
Title: RE: Move selected tables
exp tables ...
imp fromuser=old_user touser=new_user
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod
16 matches
Mail list logo