Oracle Database Discussions

Hi People

I have generated role, table space , views etc scripts from a schema.
I have the role scripts in a role folder (.sql extension), view scripts in views folder (.vw extension) etc.
Now I want to run them in another database.

But when I do like following, I get error in SQL*PLUS :

SQL> @C:\temp\Copy_WMGIS_DWH\2Roles\*.*
SP2-0556: Invalid file name.
SQL> @C:\temp\Copy_WMGIS_DWH\2Roles\*.sql
SP2-0556: Invalid file name.
SQL>

In SQL developer, I get following message:

@C:\temp\Copy_WMGIS_DWH\2Roles\*.*
Error report:
Unable to open file: "C:\temp\Copy_WMGIS_DWH\2Roles\*.*"

Please suggest me the correct way in which I can get all the scripts executed present in a folder.

Thanks.