oracle database management 12c DBMS


status:Failure -Test failed:IO Error:The Network Adapter could not establish the connection

open command prompt in admin mode then

lsnrctl status

lsnrctl start

Global database name is SID

and  host and port can be find from C:appadminproduct12.2.0dbhome_1networkadminsample

set ORACLE_SID=orcl

sqlplus /nolog

username :sys as sysdba


 password you have entered during installation of oracle

How to view properly in sql plus

open sql plus and type set line 350;
you can increase the value from 350 to as per your requirement.

To view a table

desc tablename;

To view data inside a table
select * from tablename;

How to Delete a table

you can tell SQL*Plus to autocommit your changes
SQL> set autocommit on;
SQL> <<do whatever>>
Specify CASCADE CONSTRAINTS to drop all referential integrity constraints that refer to primary and unique keys in the dropped table. If you omit this clause, and such referential integrity constraints exist, then the database returns an error and does not drop the table.
drop table tablename cascade constraints;

update to change data
and alter to add attributes or columns

Leave a Comment

Your email address will not be published. Required fields are marked *

Open chat