DROP SEQUENCE oe.customers_seq; DROP SYNONYM 用途DROP SYNONYM文を使用すると、データベースからシノニムを削除できます。また、シノニムの削除および再作成を行って、シノニムの定義を変更することもできます。参照: シノニムの詳細は、「CREATE SYNONYM」を参照してください。
In this tutorial, you will learn how to use the Oracle DROP SEQUENCE statement to remove a sequence from the database.
Inserting Sequence Values Example The following statement inserts a new row containing the next value of the departments sequence into thedepartmentstable: INSERT INTO departmentsVALUES (departments_seq.nextval, 'Entertainment', 162, 1400); Inserting into a Partition Example ...
DROP SEQUENCE [schema. ] sequence_name; ParametersParameterDescription schema. The schema where the sequence is located. If schema. is not specified, the sequence is located in the schema of the currently logged-on user. sequence_name The name of the sequence to be dropped.ExamplesDrop the ...
DROP SEQUENCE name [, ...] 说明 DROP SEQUENCE 可删除序列号生成器。要执行该命令,您必须是超级用户或序列的所有者。 参数 参数说明 name 序列的名称(可能是 schema 限定的)。 示例 删除序列 serial: DROP SEQUENCE serial; 上一篇:DROP SYNONYM下一篇:DROP TABLE ...
alter database recover managed standby database cancel; alter database open; alter database recover managed standby database disconnect from session; 5)查看DG运行状态 select process,client_process,sequence#,status from v$managed_standby; 五、完成,DG中删除了pdb,最大scn也已经变化...
nameRESTRICTSEQUENCEsequence-nameRESTRICTSERVERserver-nameservice-class-designatorRESTRICTSTOGROUPstoragegroup-nameRESTRICTTABLEtable-name2TABLE HIERARCHYroot-table-name,tablespace-nameTRANSFORMALLgroup-nameFORtype-nameTHRESHOLDthreshold-nameTRIGGERtrigger-nameTRUSTED CONTEXTcontext-nameTYPEtype-nameRESTRICTTYPE MAPPING...
nameRESTRICTSEQUENCE序列名稱RESTRICTSERVER伺服器名稱service-class-designatorRESTRICTSTOGROUPstoragegroup-nameRESTRICTTABLE表格名稱TABLE HIERARCHYroot-table-nameTABLESPACETABLESPACES,表格空間名稱TRANSFORMTRANSFORMSALLgroup-nameFOR類型名稱THRESHOLDthreshold-nameTRIGGER觸發程式名稱TRUSTED CONTEXT環境定義名稱TYPE類型名稱RESTRICT...
DROP SEQUENCE removes sequence number generators. To execute this command, you must be a superuser or the owner of the sequence. Parameters name The name (optionally schema-qualified) of a sequence. Examples Remove the sequence serial: → WrapCopy DROP SEQUENCE serial; See also A...
Oracle Transportation Management - Version 6.3.1 to 6.3.4 [Release 6.3]: ORA-02289: Sequence Does Not Exist Error Using Drop down Remark On GTM_TRANSACTION Manager