Is it possible to export a view [message #265446] |
Thu, 06 September 2007 06:01 |
ShaShalini
Messages: 59 Registered: January 2007
|
Member |
|
|
Hi
I have a view which selects records from many tables. I want to export the view and import it in another schema.
Is it possible to export Views ??? If yes , then can you tell me how . Because when I am doing export it just gives me error table or view does not exist.
My Command for export was
exp usr1/usr1 file=rocview.dmp tables=VIEW_T1 rows=y log=exproc.log
Thanks
|
|
|
|
Re: Is it possible to export a view [message #265457 is a reply to message #265450] |
Thu, 06 September 2007 06:29 |
ShaShalini
Messages: 59 Registered: January 2007
|
Member |
|
|
Thanks for the reply ..
My view is not a simple select from table, its a view of objects.
the view is created like this
create or replace view view_t1 of OBJ_T1 with OBJECT IDENTIFIER (Ser_no) as
SELECT --- statement goes on ..
OBJ_T1 is created like this
CREATE or replace TYPE OBJ_T1 as OBJECT (
ser_no varchar2(10),
|
|
and it goes on ..
When I run the statement that you provided it just gives me a single line output
CREATE OR REPLACE FORCE VIEW "USR1"."VIEW_T1" OF "USR1"."OBJT_T1"
|
|
|
|
Re: Is it possible to export a view [message #265573 is a reply to message #265465] |
Thu, 06 September 2007 11:56 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
create or replace type C2_TTyp as table of varchar2(2);
/
create or replace view v_C2_TTyp as (
SELECT x.column_value, y.dummy FROM TABLE (C2_TTyp ('A', 'B', 'C', 'D', 'E'))x, dual y);
select NAME, TYPE, REFERENCED_OWNER, REFERENCED_NAME, REFERENCED_TYPE, REFERENCED_LINK_NAME
from user_dependencies
where name = 'V_C2_TTYP'
--where ...
;
NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE REFERENCED_LINK_NAME
--------- ------- ---------------- --------------- --------------- --------------------
V_C2_TTYP VIEW SYS DUAL TABLE
V_C2_TTYP VIEW PUBLIC DUAL SYNONYM
V_C2_TTYP VIEW SCOTT DUAL NON-EXISTENT
V_C2_TTYP VIEW SCOTT C2_TTYP TYPE
[Updated on: Wed, 12 September 2007 03:50] by Moderator Report message to a moderator
|
|
|
|
|
|