Categories:

System functions (System Information)

SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUS

Returns the status of an attempt to move an organization account.

See also:

SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNT , SYSTEM$COMMIT_MOVE_ORGANIZATION_ACCOUNT

Syntax

SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUS( )

Arguments

None.

Returns

The following are the possible statuses:

CodeStatus
060050Move of the current organization account has been initiated.
060051Created a new organization account as the destination for migrating the existing organization account.
060052Objects are being replicated from the current organization account to the target organization account. Target organization account is currently locked and not ready for use.
060053Initial replication of objects is complete and the target organization account is ready to be reviewed. If you are ready to proceed with the move please run SYSTEM$COMMIT_MOVE_ORGANIZATION_ACCOUNT(<GRACE_PERIOD_IN_DAYS>).
060054Commit of organization account move in progress.
060055The move has been completed successfully. The original organization account is locked and will be deleted in x days.
060056The organization account move failed.
060057Cannot fetch status of organization account move.

Access control requirements

Only users with the GLOBALORGADMIN role can call this function.

Usage notes

Only shows the status of the latest attempt to move the organization account.

Example

SELECT SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUS();