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

8 votes162 views1 answer
Alter tablespace add datafile
SQL
2 votes175 views1 answer
Metasploit start postgresql
SQL
0 vote185 views1 answer
TSQL convert csv to table
SQL
0 vote203 views2 answers
Search stored procedures
SQL
10 votes184 views3 answers
Sql select between two dates
SQL
1 vote172 views1 answer
Search for replace in mysql
SQL
0 vote169 views1 answer
Pgsql is not permitted to log in
SQL
0 vote171 views1 answer
Java mysql swing example
SQL
0 vote231 views1 answer
Mariadb used space
SQL
0 vote168 views1 answer
Grant privileges of databse to user
SQL