Blog

Everything about Databases with dbsnoop

Tag: sql

List Tables in Any Database

Oracle To list all tables: SELECT tablespace_name, table_name, owner FROM dba_tables; To list all tables for the current user: SELECT tablespace_name, table_name, owner FROM user_tables; To list all tables the user has access to (whether the user is the owner or not):

Read more >>

MySQL 5.6 – ISL Files

To store the remote path, we additionally added the InnoDB system tables SYS TABLESPACES and SYS DATAFILES. Since the system tablespace and system tables are recovered simultaneously with all of the distant tablespaces, that path is

Read more >>
en_US
en_US pt_BR