Differences

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

--- dba:cli_commands [2025/12/02 16:30] – mlivolsi
+++ dba:cli_commands [2025/12/02 20:17] (current) – [Dumping and Restoring] mlivolsi
@@ Line 12: / Line 12: @@
 | 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> |