我在SQLSERVER中的视图导出成SQL 脚本文件...想导入到ORACLE 8I里面去..在SQL*PLUS里执行脚本文件出现截断问题..请问,导出的脚本文件.还用修改吗..我贴个简单的例子.我是菜鸟,大家说明白点..
下面为SQLSERVER导出的视图脚本文件里的内容.
if exists (select * from sysobjects where id = object_id(N'[View_TestData_Sample]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [View_TestData_Sample]SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON CREATE VIEW View_TestData_Sample
AS
SELECT Sample.*, TL.TL_ID AS TL_ID, TL.TL_Detect_Man AS TL_Detect_Man,
TL.TL_State AS TL_State, TL.TL_Creat_Date AS TL_Creat_Date,
TL.TL_Approve_Man AS TL_Approve_Man,
Customer.Customer_Name AS Customer_Name
FROM Customer INNER JOIN
SC ON Customer.Customer_ID = SC.Customer_ID INNER JOIN
SampleToSC ON SC.SC_ID = SampleToSC.SC_ID INNER JOIN
Sample ON SampleToSC.Sample_ID = Sample.Sample_ID INNER JOIN
Task ON SampleToSC.Sample_ID = Task.Sample_ID INNER JOIN
TL ON Task.TL_ID = TL.TL_IDSET QUOTED_IDENTIFIER OFFSET ANSI_NULLS ON如何能修改成ORACLE可以导入的SQL脚本文件.
下面为SQLSERVER导出的视图脚本文件里的内容.
if exists (select * from sysobjects where id = object_id(N'[View_TestData_Sample]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [View_TestData_Sample]SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON CREATE VIEW View_TestData_Sample
AS
SELECT Sample.*, TL.TL_ID AS TL_ID, TL.TL_Detect_Man AS TL_Detect_Man,
TL.TL_State AS TL_State, TL.TL_Creat_Date AS TL_Creat_Date,
TL.TL_Approve_Man AS TL_Approve_Man,
Customer.Customer_Name AS Customer_Name
FROM Customer INNER JOIN
SC ON Customer.Customer_ID = SC.Customer_ID INNER JOIN
SampleToSC ON SC.SC_ID = SampleToSC.SC_ID INNER JOIN
Sample ON SampleToSC.Sample_ID = Sample.Sample_ID INNER JOIN
Task ON SampleToSC.Sample_ID = Task.Sample_ID INNER JOIN
TL ON Task.TL_ID = TL.TL_IDSET QUOTED_IDENTIFIER OFFSET ANSI_NULLS ON如何能修改成ORACLE可以导入的SQL脚本文件.
CREATE or replace VIEW View_TestData_Sample
AS
SELECT Sample.*, TL.TL_ID AS TL_ID, TL.TL_Detect_Man AS TL_Detect_Man,
TL.TL_State AS TL_State, TL.TL_Creat_Date AS TL_Creat_Date,
TL.TL_Approve_Man AS TL_Approve_Man,
Customer.Customer_Name AS Customer_Name
FROM Customer
INNER JOIN SC ON Customer.Customer_ID = SC.Customer_ID
INNER JOIN SampleToSC ON SC.SC_ID = SampleToSC.SC_ID
INNER JOIN Sample ON SampleToSC.Sample_ID = Sample.Sample_ID
INNER JOIN Task ON SampleToSC.Sample_ID = Task.Sample_ID
INNER JOIN TL ON Task.TL_ID = TL.TL_ID;
--- ------------ ----
1 q 1
2 w 1
3 e 1
4 r 1
5 t 1
6 y 2
7 u 2
8 i 2
9 o 2
10 p 2
11 a 3
12 s 3
13 d 3
14 f 3
15 g 3
16 h 316 rows selectedSQL>
SQL> create or replace view testview
2 as
3 select a.id,b.id as idx from t a
4 cross join t b;View created