Differences

This shows you the differences between two versions of the page.

--- dba:cli_commands [2025/12/02 16:26] – mlivolsi
+++ dba:cli_commands [2025/12/02 20:17] (current) – [Dumping and Restoring] mlivolsi
@@ Line 7: / Line 7: @@
 | Show databases (schema) |<code>select distinct owner
 from dba_objects
-where owner =' '</code>| show databases |  |
+where owner =' '</code>| show databases | \l |
 | Query Buffer | list | <up arrow >  | \p |
 | Quit / Exit | exit | exit | \q |
+| Display users |select * From dba_users;| | \du |
+| Display Schemas | <same as show databases> | | \dn |
+| Connect to a new DB | . |  | connect database |
+| Dropping a schema | drop user <username> cascade | drop database <database_name> | drop schema <schema_name> cascade; ←- Will drop the schema and all objects |
+| Show all tables | select * From dba_tables where owner = <owner> | show tables | \dt+ <schema_name>.* |
+==== Privs ====
+^ Command ^ Oracle ^ MySQL  ^ Postgres ^
+| create user | create user <username> identified by <password>; | Same as Oracle | Create user <username> password <password>; |
+==== Dumping and Restoring ====
+^ Command ^ Oracle ^ MySQL  ^ Postgres ^
+|dumping | expdp | mysqldump | pg_dump |
+|Restore | impdp | mysql > source <file_name> | psql > \i <file_name> |