Oracle compile schema

-- Compiles all objects of a schema
BEGIN
	-- compile_all: true compiles all, false compiles invalid objects only
	DBMS_UTILITY.compile_schema(schema => 'My_SCHEMA', compile_all => true);
END;

Source: grepper.com

Similar codes

1 vote188 views2 answers
Oracle list service names
SQL
0 vote187 views1 answer
One table with another
SQL
15 votes276 views4 answers
Mysql export database command line
SQL
0 vote182 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote204 views4 answers
Forenkey code alchemy sql
SQL
3 votes196 views2 answers
How to start mysql in terminal
SQL
-1 vote142 views2 answers
On delete set default sql server
SQL
1 vote241 views1 answer
Varchar plsql
SQL
0 vote187 views1 answer
How to install mysql without admin rights
SQL
-2 votes192 views1 answer
Modify column name in tsql
SQL