Skip to content

Home
About Me
Toggle search form
Search for:

find_cons.sql Oracle
How to Decide upto what level you can decrement your datafile size. ( Shrink Datafile) Oracle
Identical Dblink Issue… Oracle
Index Range Scan Oracle
fuser to check who is using diretory Linux/Unix
executing Function from SQLPLUS prompt Oracle
DBMS_JOB all example Oracle
fkwoind.sql fkwoindex.sql Oracle
Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1 Oracle
Wait time tuning research Oracle
Export Oracle data and Compress at same time Oracle
DETERMINING WHICH INSTANCE OWNS WHICH SHARED MEMORY & SEMAPHORE SEGMENTS Oracle
export import with parameter file. Oracle
Unix split command to split files Linux/Unix
Find Command Linux/Unix

tab.sql

Posted on 02-Aug-2005 By Admin No Comments on tab.sql

select table_name, tablespace_name from dba_tables

where owner = upper(‘&usrnm’)

order by table_name

/

Oracle, SQL scripts

Post navigation

Previous Post: login.sql

Next Post: findx.sql /* Find Indexes on specified USER.TABLE_NAME */

Related Posts

Changing Instance Name ( No DB_NAME) Oracle
Temporary Tablespsace Temp tablespace behaviour Oracle
Optimizer_Index init.ora parameter explaination. Oracle
myfile Oracle
How to connect to Oracle Database with Wallet with Python. Oracle
Privileges Required to Create Procedures and Functions that uses objects from other schema. Oracle

Leave a Reply Cancel reply

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

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Categories

AWS (2)
Azure (1)
Linux/Unix (149)
Oracle (387)
PHP/MYSQL/Wordpress (10)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (149)
SQL scripts (336)
Uncategorized (0)
Videos (0)

Recent Posts

SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
How to connect to Oracle Database with Wallet with Python.21-Mar-2025
JSON/XML Types in Oracle18-Mar-2025
CPU Core related projections12-Mar-2025
Exadata Basics10-Dec-2024
Reading config file from other folder inside class24-Sep-2024
Python class import from different folders22-Sep-2024
Transfer SQL Profiles from One database to other database.05-Sep-2024
Load testing on Oracle 19C RAC with HammerDB18-Jan-2024
Add new columns in dataframe30-Sep-2023

Archives

2025
2024
2023
2010
2009
2008
2007
2006
2005

Good notes for shared pool Oracle
DBMS_JOB all example Oracle
PHP code to add WordPress posts in bulk programmatically PHP/MYSQL/Wordpress
How to remove blank lines using vi editor command Linux/Unix
Oracle Material from OTN Oracle
catting.sh Linux/Unix
Changing Instance Name ( No DB_NAME) Oracle
CPU speed on solaris Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme