dbaccess 데이타베이스_이름 스크립트_이름 해주시면 되겠죠.
답이 됐는지 궁금하네요.
-- 노현근 님이 쓰신 글:
>> 오라클에서 사용한 스크립트
>> create table Dis_User (
>> Dis_Sequenceid number(15) NOT NULL,
>> Dis_Crestedby varchar2(30) NOT NULL,
>> Dis_Createdate date NOT NULL,
>> Dis_Modifiedby varchar2(30) NOT NULL,
>> Dis_Modifieddate date NOT NULL,
>> Dis_Name varchar2(30) NOT NULL,
>> Dis_Empid varchar2(10) PRIMARY KEY,
>> Dis_Password varchar2(20),
>> Dis_Email varchar2(50),
>> Dis_Groupid number(15) NOT NULL,
>> Dis_Assigneegroupid varchar2(30) NOT NULL,
>> Dis_Deptname number(1) NOT NULL,
>> Dis_Appyn varchar2(14),
>> Dis_Cell varchar2(14),
>> Dis_Tel varchar2(14),
>> Dis_Faxno varchar2(10),
>> Dis_Deptcode varchar2(20) NOT NULL,
>> Dis_IPaddress number(1),
>> Dis_Class varchar2(40),
>> Dis_Residentno varchar2(13),
>> Dis_Worknamecode varchar2(10),
>> Dis_Classcode varchar2(10) NOT NULL,
>> Dis_Hobongcode varchar2(10) NOT NULL,
>> Dis_Enteringdate date,
>> Dis_Expireddate date,
>> Dis_Incubmentstatus varchar2(1),
>> constraint Dis_Sequenceid_UK UNIQUE (Dis_Sequenceid)
>> );
>> create index Dis_Deptname_IDX ON Dis_User (Dis_Deptname);
>> create index Dis_Appyn_IDX ON Dis_User (Dis_Appyn);
>> create index Dis_Deptcode_IDX ON Dis_User (Dis_Deptcode);
>>
>> 어떻게 해야 하는지 자세히 알려주세요
>> 감사 합니다.
|