Editing Sequences

Edit online database sequences and offline and modeled sequences from the Edit Sequence dialog, or the Edit Offline Sequence dialog.

To edit an online sequence:

1. Select View Connection Navigator.
2. Expand Database and select a database connection.
3. In the connection, expand a schema.
4. In the schema, expand Sequences.
5. Right-click a sequence name and select Edit , or double-click the sequence name.
6. The Edit Sequence dialog opens.
7. In the pages of the wizard enter parameters and select options to define the sequence.

To edit an offline sequence:

1. In the navigator, expand the workspace, project, and schema.
2. Right-click the offline sequence and choose P roperties.
   Or
   Double-click the offline sequence.
3. The Edit Offline Sequence dialog opens.
4. In the pages of the wizard enter parameters and select options to define the sequence.

To edit an offline sequence:

1. In the navigator, expand the workspace, project, and schema.
2. Right-click the offline sequence and choose P roperties.
   Or
   Double-click the offline sequence.
3. The Edit Offline Sequence dialog opens.
4. In the pages of the wizard enter parameters and select options to define the sequence.

For information about how to fill in values for the the dialog parameters and options, click Help in the dialog, or see the CREATE SEQUENCE section of the Oracle Database SQL Reference at http://www.oracle.com/technology/documentation/database10g.html.

Copyright © 1997, 2004, Oracle. All rights reserved.