High Efficiency with SQL Developer 12c


Oracle SQL Developer is a graphical version of SQL*Plus that gives database developers a convenient way to perform basic tasks. You can browse, create, edit, and delete (drop) database objects; run SQL statements and scripts; edit and debug PL/SQL code; manipulate and export (unload) data; and view and create reports.

You can connect to any target Oracle database schema using standard Oracle database authentication. Once connected, you can perform operations on objects in the database.

You can connect to schemas for selected third-party (non-Oracle) databases, such as MySQL, Microsoft SQL Server, Sybase Adaptive Server, Microsoft Access, and IBM DB2, as well as view metadata and data in these databases; also you can migrate third-party databases to Oracle

task#5 Use SQL Developer and do the following: without any SQL or PL/SQL code writing, alter the state of the pluggable database PDBORCL from open to close, then change its state again from close to open.

step#1 – Start SQL Developer, open the View menu DBA, and click on the Option Container Database. That option will allow the management of the Container Database CDB and the Pluggable Databases PDBs. Then, open the window with the status of the pluggable database PDBORCL.

Start SQL Developer

Start SQL Developer

Open View Menu and Option DBA

Open View Menu and Option DBA

Open Option Container Database

Open Option Container Database

step#2 – Open the list of actions on PDBORCL

Modify PDB state

Modify PDB state

step#3 – Close the pluggable database PDBORCL

Apply Modify PDB State to Close

Apply Modify PDB State to Close

Successful State Modification To Close

Successful State Modification To Close

PDB is Closed

PDB is Closed

step#4 – Open the pluggable database PDBORCL in Read Write mode

Modify PDB state From Close To Open

Modify PDB state From Close To Open

Apply Change From Close To Open

Apply Change From Close To Open

PDB is successfully OPENed

PDB is successfully Opened

PDB status is OPEN in Read Write mode

PDB status is OPEN in Read Write mode

Summary

SQL Developer offers to DBAs and Oracle Developers efficient control over root CDB and pluggable PDBs. Productivity of DBAs and Oracle Developers is increased more than ever with Oracle Database 12c Tools.

References

Oracle 12c documentation

[ref7] Oracle® SQL Developer User’s Guide Release 3.2 E35117-06

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s