What different things get stored in system,sysaux ,temp and users tablespace?
No Comments Posted for this Article.
Procedure Vs Stored Procedure in Oracle
Hello everyone, I am an Oracle novice. When I googled, I am getting some confusions. What is the main difference between procedure vs Stored procedure in Oracle PL/SQL? Thanks
Oracle : Unlimited Tablespace, User Creation
Hi, I’m new to Oracle 9i using R2. I’m currently logged in as sysdba and currently tried creating a new user: SQL> create user john identified by oracle 2 default tablespace...
How much tablespace size and UNDO tablespace
Hi all, We have SAP ver 4.7 and Oracle 9.2.0 on Windows 2000. Recently we upgraded oracle version from 8.1.7 to 9.2.0 and we did database reorg also. While doing database reorg we...