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;

Similar codes

4 votes202 views4 answers
Check constraint in ms sql
SQL
5 votes273 views4 answers
Restart the psql server windows
SQL
0 vote177 views1 answer
Error code 1241 mysql
SQL
3 votes203 views4 answers
Truncate syntax in sql
SQL
-1 vote195 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote213 views1 answer
Update sqlite
SQL
0 vote245 views1 answer
What is default mysql database password in linux
SQL
4 votes184 views2 answers
Postgresql reset sequence
SQL
0 vote218 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote218 views1 answer
How to enable mysql 5.7 root user password on linux
SQL