PATSTAT - ORACLE loading scripts

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.

Fr3dY
Posts: 26
Joined: Mon Oct 17, 2016 8:57 am

PATSTAT - ORACLE loading scripts

Post by Fr3dY » Mon Oct 17, 2016 3:31 pm

Hi,

I'm sharing the scripts I wrote for loading PATSTAT into ORACLE.
Please try and give some feedback, I hope it works well for you.

[Older versions available on demand]

PATSTAT 2023 AUTUMN Edition:
https://filetransfer.io/data-package/uGV3oWF1#link

PATSTAT 2023 SPRING Edition:
https://filetransfer.io/data-package/1Pbherb8#link

Don't forget to take a look at the README files before trying!


Regards,
Last edited by Fr3dY on Mon Nov 27, 2023 9:37 am, edited 23 times in total.


Fr3dY
Posts: 26
Joined: Mon Oct 17, 2016 8:57 am

Re: PATSTAT - ORACLE loading scripts

Post by Fr3dY » Tue Oct 31, 2017 4:12 pm

Updated: Added scripts for Patstat 2017 Autumn Edition


Fr3dY
Posts: 26
Joined: Mon Oct 17, 2016 8:57 am

Re: PATSTAT - ORACLE loading scripts

Post by Fr3dY » Tue Apr 24, 2018 3:22 pm

Update: Added scripts for Patstat 2018 Spring Edition


EPO / PATSTAT Support
Posts: 425
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: PATSTAT - ORACLE loading scripts

Post by EPO / PATSTAT Support » Wed Apr 25, 2018 10:35 am

Many thanks.
:)
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Fr3dY
Posts: 26
Joined: Mon Oct 17, 2016 8:57 am

Re: PATSTAT - ORACLE loading scripts

Post by Fr3dY » Mon Nov 12, 2018 5:16 pm

Update: Added scripts for Patstat 2018 Autumn Edition


GROW.R3
Posts: 2
Joined: Wed Feb 20, 2019 12:27 pm

Re: PATSTAT - ORACLE loading scripts

Post by GROW.R3 » Wed Feb 20, 2019 12:37 pm

Good Mornings,
There is a different way to receive PATSTAT 2018 AUTUMN Edition - Oracle Script, such as e-mail?
It is impossible for me to download it from tinyupload for security reasons.
The TinyUpload.com site is blocked by our proxy due to its poor reputation.
Regards.


Fr3dY
Posts: 26
Joined: Mon Oct 17, 2016 8:57 am

Re: PATSTAT - ORACLE loading scripts

Post by Fr3dY » Thu Feb 21, 2019 9:11 am

GROW.R3 wrote:
Wed Feb 20, 2019 12:37 pm
Good Mornings,
There is a different way to receive PATSTAT 2018 AUTUMN Edition - Oracle Script, such as e-mail?
It is impossible for me to download it from tinyupload for security reasons.
The TinyUpload.com site is blocked by our proxy due to its poor reputation.
Regards.
Hi,

Send me a private message with your email address.
Just in case, I've uploaded it to https://ufile.io/uy57w - maybe this one is not blocked for you.




Regards,


Fr3dY
Posts: 26
Joined: Mon Oct 17, 2016 8:57 am

Re: PATSTAT - ORACLE loading scripts

Post by Fr3dY » Fri May 17, 2019 3:49 pm

Update: Added scripts for PATSTAT 2019 Spring Edition


EPO / PATSTAT Support
Posts: 425
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: PATSTAT - ORACLE loading scripts

Post by EPO / PATSTAT Support » Fri May 17, 2019 6:44 pm

1 day after release !
Fantastic, that was quick :D
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


GROW.R3
Posts: 2
Joined: Wed Feb 20, 2019 12:27 pm

Re: PATSTAT - ORACLE loading scripts

Post by GROW.R3 » Tue Jul 02, 2019 3:22 pm

Fr3dY wrote:
Fri May 17, 2019 3:49 pm
Update: Added scripts for PATSTAT 2019 Spring Edition
Could you do the same for the new version you made for PATSTAT 2018 AUTUMN Edition?
Or can you tell me how to send you a private message to your email address?

Regards


Post Reply